[SOLVED] Using array values to select from mysql table

[peuge]

Hi all,

 

So I have a table for bookings and I have taken all the bookings from that table within a selected date range. So if a user selects a date range it return all the booked rooms within that date range. Now what I want to do it take all the room numbers from table_rooms that are not booked. So I have the room numbers that are booked stored in an array and need to select all the rooms which are not in that array?

 

I would need a loop of some sort, but cant figure out the mysql query to execute this?

 

Any help much appreciated.

 

Thanks in advance

[peuge]

I have figured it out. I put all the room numbers into array, then all the booked room numbers into another array then made a new array with array_diff

[fenway]

You could do this in mysql, too....