Can somebody help with this please.
I have a variable $uniqueid which is an array.
I need a select statement to do this:
select bookingid, datebooked from bedsbooked where datebooked > today and booking id does not equal any of the values in the variable $uniqueid, ordered by datebooked
Here is an example of how the mysql table is set up.
bookingid datebooked 73 2010-10-15 73 2010-10-14 74 2010-09-25 75 2010-08-24 76 2010-08-18 77 2010-08-18
I realise now that there are better ways to structure the table which would simplyfy what I am trying to do, but for the time being am not in a position to make those changes.