Originally Posted by darkagn

Couple of quick points:

ID fields should never be a text field. Use Unsigned INT or something similar. This helps efficiency and referential integrity of your tables.

Think about maybe consolidating the three columns Dayofweek, Timeslot and AMPM into one column, TimeOfDay, and making it a smalldatetime field, which is much nicer to work with than a straight text for dates and times.
Photo - you have a couple of choices, either this is a filename to the image of a photo, or better still make this a varbinary field and store the image's binary data directly in the database.

Ok, that said, for an SQL statement to list all shows by day and time, something like

Help with Code Tags

sql Syntax (Toggle Plain Text)

SELECT * FROM TableName
ORDER BY TimeOfDay ASC

SELECT * FROM TableName ORDER BY TimeOfDay ASC

should do for a start. You can always refine this statement with a WHERE clause to limit to a specific date if you want:

Help with Code Tags

sql Syntax (Toggle Plain Text)

SELECT * FROM TableName
WHERE TimeOfDay > '2008-07-17 00:00:00'
AND TimeOfDay < '2008-07-17 23:59:59'
ORDER BY TimeOfDay ASC

SELECT * FROM TableName WHERE TimeOfDay > '2008-07-17 00:00:00' AND TimeOfDay < '2008-07-17 23:59:59' ORDER BY TimeOfDay ASC

Hope this helps
darkagn