Work week layout for mysql query

[lspiehler]

I've got a table with 5 columns that shows appointments for Monday through Friday, but I'm using 5 separate queries, one for each column, for each corresponding day because i cannot figure out how to query the whole week and only put the appointments in the column they belong. Thank you for any help.

[nderevj]

I'm not a database expert by any means but I think a redesign of the schema might be in order. My suggestion is to create an "appointments" table that contains various appointment information (name, location, agenda / notes, date, etc). You would then query on the appointments table's date column. Something like:

 

SELECT * FROM appointments WHERE date BETWEEN '01/10/2011' AND '01/14/2011';

 

The date range would be the 5 days / week you need. You also might need to have the end date 1 day later- 01/15/2011. (Excuse my lack of database skills)