Hi, well my boss said the format for the date in our database is mm/dd/yyyy and when i get the current_date() to compare the two I have the problem of them being different
current_date() is yyyy-mm-dd (right?)
event_startDate is mm-dd-yyyy
I tried using the get_format() function to get them to be the same but it doesnt seem to be working correctly.
What I am trying to do is write a query that gets the information for the next upcoming meeting. Thus, the events_startDates needs to be greater than the current_date() and i merely grab the "closest" meeting or the first row as it were.
This is what i have so far. How do I get the dates to be comparable to each other?
$query = mysql_query("SELECT * FROM meeting_list, events WHERE event_startDate > current_date() AND eventID = ID AND event_type != 'Sales' ORDER BY event_dates ASC LIMIT 1");