Results 1 to 2 of 2
Thread: making a tv schedule?
Oct 20, 2002, 14:05 #1
- Join Date
- Jul 2001
- Los Angeles
- 0 Post(s)
- 0 Thread(s)
making a tv schedule?
I’m creating a TV schedule viewer and wanted to get some advise from all of you since I’m fairly new to PHP.
I have a table in a mySQL database that looks like this:
TIME DATE NAME 18:00 10/20/02 SHOW1 18:30 10/20/02 SHOW5 05:30 10/21/02 SHOW8
MONDAY TUESDAY WEDNESDAY … 8:00 SHOW1 SHOW4 SHOW9 8:30 SHOW3 SHOW8 SHOW5
I assume that passing a new query for every day/time would not be very efficient (ie. SELECT name FROM schedule WHERE DATE=”10/20/02 AND TIME=”08:00”, SELECT name FROM schedule WHERE DATE=”10/20/02 AND TIME=”08:30”).
Any suggestions on how to go about this as easily and most efficiently as possible?
Thanks for any help you may offer!
Oct 21, 2002, 10:58 #2
Moved to a more appropriate forum. If the thread moves into more of a PHP discussion I will move it back
-- You lived inside my world so softly
-- Protected only by the kindness of your nature