You can order everything but you must be carefull in the database design.
Select "program" from "table" order by "time"
Where "time" is a DATE value in your database. In mysql you have a variety the
formats. For example,
DATETIME: YYYY-MM-DD hh:mm:ss
Maybe you need use a good book related to SQL. The Practical SQL Handbook is a
Matthew Cothier wrote:
> The other thing that I have been asked to design is an online tv guide for a
> list of shows. Basically I want to be able to display a list of programmes
> on the front page for the current date in time order. Can this be done in
> the same way as alphabetical ordering?
> I will also have a seperate page for each individual show with listings for
> that show only, as well as details about the show an episode guide etc...
> And if that isn't enough I want people to be able to search for a show or a
> specific date via a search box.....how exactly do I do a query?
> AND to select from a drop down box the date they want to view on the front
> page....how would I display two weeks worth of days in a select form from
> the date that they view the page?
> Again thankyou! I have lotsof pieces to the puzzle its just gaining more
> pieces and fitting it together. If anyone can help with any of this
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]