Re: Sorting alphabetically and Tv guide

Hi! 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 good book. Regards, Matthew Cothier wrote: > Thanks! > > 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 > Thankyou! > _________________________________________________________________________ > 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net