CodeIgniter Forums

Full Version: Current date in where query
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi all,

I am just trying to get some results to only show upcoming events only.  So I am trying to get it to get the date that someone is looking at the page and grab from that date onward.

PHP Code:
$this->db->where('date >='DATE()); 

I have tried to use this that people online have said to use but I just get errors and I have tried NOW(), GETDATE() and nothing seems to work.

Doomie
if your field is a datetime, you can use
PHP Code:
date('Y-m-d H:i:s'

if your field is a timestamp, you can use
PHP Code:
time()