Sorting results by time and date
Posted: Fri Sep 12, 2008 8:10 am
Hi
I have written a flash/php app that pulls records out of a MySQL database and populates variables in the flash movie. That it works OK but what I am trying to do is the following:
I have a series of football fixtures with a date and kick-off time. I want to be able to automatically show the next game in the list at the time it is requested but for some reason it pulls up the right date but not the right time.
How do I select the next result according to TIME and DATE?
I am using dreamweaver connecting to MySQL through PHP. What would be the correct syntax for the MySQL/PHP query?
Many thanks
Peter
I have written a flash/php app that pulls records out of a MySQL database and populates variables in the flash movie. That it works OK but what I am trying to do is the following:
I have a series of football fixtures with a date and kick-off time. I want to be able to automatically show the next game in the list at the time it is requested but for some reason it pulls up the right date but not the right time.
How do I select the next result according to TIME and DATE?
I am using dreamweaver connecting to MySQL through PHP. What would be the correct syntax for the MySQL/PHP query?
Many thanks
Peter