jackel15 Posted March 28, 2009 Share Posted March 28, 2009 I am trying to create a section on my page that displays upcoming events. What is the quickest way to set up the table and have it pull only the dates that haven't passed yet? Thanks, Chris Link to comment https://forums.phpfreaks.com/topic/151481-selecting-from-table-by-date/ Share on other sites More sharing options...
gnawz Posted March 28, 2009 Share Posted March 28, 2009 SQL that pulls data greater based on date greater than current date ie $sql = SELECT * FROM table where Date(date field) > CURDATE(); Hope it hepls Link to comment https://forums.phpfreaks.com/topic/151481-selecting-from-table-by-date/#findComment-795737 Share on other sites More sharing options...
jackel15 Posted September 30, 2009 Author Share Posted September 30, 2009 Thanks Man, sorry I didn't get back sooner. Link to comment https://forums.phpfreaks.com/topic/151481-selecting-from-table-by-date/#findComment-927769 Share on other sites More sharing options...
gnawz Posted October 4, 2009 Share Posted October 4, 2009 No problem. Link to comment https://forums.phpfreaks.com/topic/151481-selecting-from-table-by-date/#findComment-930037 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.