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 Quote Link to comment Share on other sites More sharing options...
litebearer Posted March 23, 2011 Share Posted March 23, 2011 what code have you tried thus far? Quote Link to comment 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 Quote Link to comment 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 Quote Link to comment 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.