Jump to content


This topic is now archived and is closed to further replies.


Help pls. Find records NOT in 1 table but in another

Recommended Posts

Hi folks, been away for a bit, and forgotten some things, anyhow, can you pls help.  I have 2 tables in a DB, one contains a list of "rooms' the other is for room availability. - based on date.

All I want to do is find out which rooms are available on certain dates. e.g:

$sql = "SELECT * FROM roomlist
  LEFT JOIN roomavailability ON roomavailability.roomlistID=roomlist.roomlistID
  WHERE roomavailability.datefrom BETWEEN $adate AND $departdate
  AND roomavailability.dateto BETWEEN $adate AND $departdate";
  $rs  = mysql_query($sql) or die("Error: " . mysql_error());
  while ($row = mysql_fetch_array($rs, MYSQL_ASSOC))
  echo  $row['roomlistID'];

This query gives me the right results for rooms that have been booked, but  what I actually want is roomlistID from roomlist if it is not in the above query.  understand?

Help much appreciated, thanks

Share this post

Link to post
Share on other sites
this may be a real dumb answer, but you are saying you want the opposite result, right? did you try

... roomavailability.roomlistID != roomlist.roomlistID ....


Share this post

Link to post
Share on other sites
Sorry but ... roomID!=roomlist.roomlistID does not give the result I want.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.