I doing a simple reservation system and i am trying to figure whats the right query if the room is already booked?.. i only know basic mysql queries . any help would be much appreciated . thank you. here is my DB Table .

select * from {tablename} where CheckOut is null or CheckOut <= GETDATE()

Sorry, I should confirm, MySQL or MSSQL?

 pls expln in more detail

You can use the query given by andrewjboyd;

select * from <specify your table name here> where CheckOut <= GetDate() or ChechkOut is null

by which you will get  the details of the room which are not available[already booked], the

"getdate function will get you the current date."

think u dont need more explanations.

just do this query to understand getdate () 

select getdate(), if you want only the datepart then do

  Select convert(varchar, getdate(), 105)