Current date in where query - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24) +--- Thread: Current date in where query (/showthread.php?tid=64760) |
Current date in where query - doomie22 - 03-22-2016 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 RE: Current date in where query - keulu - 03-22-2016 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() |