PHP Program Schedule
| From: | Jay Fitzgerald | Date: | Mon, 07 Apr 2003 15:44:44 +0000 |
| Subject: | PHP Program Schedule | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26905@lists.php.net to get a copy of this message | ||
I am creating a weekly program schedule for a local tv station and I am also a newbie at mysql and php.
I currently have my db setup as such:
Field Type Null Key Default Extra--------- ---------------- ------ ------ ---------- --------------
airid int(10) unsigned PRI (NULL) auto_increment startdate date 0000-00-00 enddate date 0000-00-00 airtime time 00:00:00 airshow text airlength int(3) 0here is a snippet of what is in my table: select * from schedule order by startdate;
airid startdate enddate airtime airshow airlength------ ---------- ---------- -------- ---------------- ---------
1 2003-04-07 2003-04-07 05:30:00 The Lesson 30 8 2003-04-07 2003-04-11 06:00:00 Living the Life 30I want to display the data in a table like this: http://www.kcla-tv.com/admin2/help.php ** Note the ROWSPAN on Sunday at 6:00 AM and the COLSPAN's on Monday through Friday -- The above table example was hardcoded as an example Is this possible? Does anyone have any examples on doing this? Jay Fitzgerald, Design Director - CPW-A, CPWDS-A, CPWDV-A, CECM-A, CWCSB-A Bayou Internet - http://www.bayou.com Toll Free: 888.30.BAYOU (22968) Vox: 318.338.2034 / Fax: 318.338.2506 E-Mail: jayfitz@bayou.com ICQ: 38823829 / AIM: bayoujf / MSN: bayoujf / Yahoo: bayoujf