MySQL Select+PHP

[01hanstu]

Hi, Hope you can help.

 

Basically I am trying to create a page within my booking system, where people are able to view

any bookings they have made.

 

My MySql Table look like this:

 

Start_Date mon1 Mon2 mon3 Mon4 Mon5 ... (To Friday)

2009-11-16 00:00:00 Teachers Name Teachers Name  FREE FREE Teachers Name

 

Users names are fixed, as we use IIS Auth through the domain, so it will make it easier for

the staff to use.

 

I had a bash at trying to find/make some code but no luck:

 

"SELECT * FROM it_booking_$room

 

$room is set when they select the room.

 

Please Help

01HanStu