PHP Select query

[01hanstu]

Hi,

I have a table within my database named it_booking_ict1, ict2 etc and within each table it the following (cut down here) layouts, rows:

 

start_week                  mon1  mon2  monclass1 monclass2  mon1changed mon2changed etc...

2012-03-12 00:00:00  FREE  FREE  NULL        NULL          2012-03-13    NULL

 

When a booking is made it updates the mon1 with the username, monclass1 with the class and adds the date to mon1changed. I am trying to make a select query that will show the bookings made for this week (staff can only book for the current week).

 

I hope this makes sense, if anyone has any ideas i'd greatly appreciate it.

 

Stu,

[AyKay47]

select columns from table where date <= DATE_ADD( NOW(), INTERVAL 7 DAY )

 

this is assuming that you do not have dates in the past.

[fenway]

I always prefer:

 

select columns from table where date <= NOW() + INTERVAL 7 DAY