Jump to content

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


llandudno

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

Archived

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

×
×
  • Create New...

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.