Checking the availability of rooms

by

If a customer is currently checked into a room, what do you have in the checkout column? If it’s null, then you can use checkout is null for your query or modify that part as you deem fit. 

select count(*) from room where roomtype="DeluxeRoom" and roomnumber not in (
select room.roomnumber from room, reservation, roomreserve where room.roomtype="DeluxeRoom" and roomreserve.roomnumber = room.roomnumber and roomreserve.reservationid = reservation.reservationid and checkout is null)

You might also add a checked_out flag to Reservation table, to make your query easier.

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  2. How can create Database using url or other method [duplicate]
  3. Problame with files on SQL
  4. Commands out of sync; you can’t run this command now
  5. SELECT COUNT(*) AS count – How to use this count
  6. Get table column names in MySQL?
  7. How to resolve ambiguous column names when retrieving results?
  8. Loading .sql files from within PHP
  9. selecting unique values from a column
  10. Use bound parameter multiple times
  11. I cannot get my login form to connect interact properly with mySQL database [closed]
  12. mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]
  13. Increment value in MySQL update query
  14. Create a dynamic mysql query using php variables
  15. PHP: multiple SQL queries in one mysql_query statement
  16. How to separate DATE and TIME from DATETIME in MySQL?
  17. Do SQL connections opened with PDO in PHP have to be closed
  18. How to convert ISO8601 to Date format in php
  19. MySQL skipping first row
  20. How to reverse order output of a MySQL query
  21. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  22. How to generate unique id in MySQL?
  23. Fatal error: Call to a member function query() on null
  24. How would I implement a simple site search with php and mySQL?
  25. How to check if a value already exists to avoid duplicates?
  26. UNION syntax in Cakephp
  27. MYSQL select a piece of a string and order by that piece
  28. How do i search from serialize field in mysql database?
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment