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) 0
here 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 30
I 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
