• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.