How to get the current date using php

I am having trouble to get my current date of my system to compare it under my sql statement.

This is my sql statement:

    $sql = "SELECT event_registrant.eventID, event_registrant.userID, eventTitle, enddate FROM event_registrant
LEFT JOIN hotel_event ON event_registrant.eventID = hotel_event.eventID
LEFT JOIN users ON event_registrant.userID = users.userID WHERE enddate > " . date("Y/m/d");

Actually I want to compare my enddate with my currentdate and do some processing through it.

You should Always use mysql function doing SQL operations , Ask me , I faced lots of issues.

    $sql = "SELECT event_registrant.eventID, event_registrant.userID, eventTitle, enddate FROM event_registrant
LEFT JOIN hotel_event ON event_registrant.eventID = hotel_event.eventID
LEFT JOIN users ON event_registrant.userID = users.userID WHERE enddate > CURDATE()";

Notice use of CURDATE().

EDIT

use hotel_event.enddate at the end instead of plain enddate , I hope enddate is of table hotel_event . If there are more than 1 table , always use Alias table name.

Related Articles