Sorry, I posted this in the wrong area (I'm using MySQL)
I'm currently building a website for a radio station and I want to setup a programming lineup. The fields I'm using are:
Dayofweek (Show Day)
Timeslot (Show Time)
AMPM (AM or PM)
Name (Host Name)
Bio (Host Bio)
Photo (Host Photo)
I set these all up as TEXT as I wasn't sure how to do it correctly.
I want to be able to make a schedule listing the shows by Day of Week and then by Time, and I also want to make a box showing the current program on the air.
Any ideas for a newbie????