Welcome Guest, Not a member yet? Register   Sign In
Current date in where query
#1

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
Reply
#2

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() 
Reply




Theme © iAndrew 2016 - Forum software by © MyBB