richeyrich_86 Posted March 23, 2011 Share Posted March 23, 2011 Hi i need help iv create an event upload on the back-end of a website where a user can enter name, location and date of an event into sql database which works fine, the problem is that i want to display only current and up and coming events and not display the events that have passed if anyone can help that would be great Link to comment https://forums.phpfreaks.com/topic/231518-only-display-current-and-up-and-coming-event/ Share on other sites More sharing options...
litebearer Posted March 23, 2011 Share Posted March 23, 2011 what code have you tried thus far? Link to comment https://forums.phpfreaks.com/topic/231518-only-display-current-and-up-and-coming-event/#findComment-1191434 Share on other sites More sharing options...
will35010 Posted March 23, 2011 Share Posted March 23, 2011 We would have to see your database schema to really help and see what data is stored, but I would just write a query with a time function to only pull those events that you want. I don't know how you are storing your time values, but look at mySQL's time functions here http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html Link to comment https://forums.phpfreaks.com/topic/231518-only-display-current-and-up-and-coming-event/#findComment-1191436 Share on other sites More sharing options...
richeyrich_86 Posted March 24, 2011 Author Share Posted March 24, 2011 its ok now a friend helped me sort it out thanks tho Link to comment https://forums.phpfreaks.com/topic/231518-only-display-current-and-up-and-coming-event/#findComment-1191881 Share on other sites More sharing options...
searls03 Posted March 24, 2011 Share Posted March 24, 2011 hey richey rich, I am trying to achieve the same thing..........what did you have to do? Link to comment https://forums.phpfreaks.com/topic/231518-only-display-current-and-up-and-coming-event/#findComment-1191916 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.