compare date and compare availability

[cassbiz]

What I would like to do is run two queries with a single output.

for example my first query is:

<?
$query = "(SELECT spacenummer FROM res WHERE arrival BETWEEN '$var_from' AND '$var_to' OR departure BETWEEN '$var_from' and '$var_to';)";
?>
 

and the second query is

$query1 = "(SELECT spacenummer FROM spaces;)";
 

The table spaces lists all of the available spaces.
The table res lists all booked spaces and dates.

I would like to find out if in the given date range a space is available then to show it in an output and/or give either a yes or no.

Thanks in advance

[cassbiz]

What I would like to do is run two queries with a single output.

for example my first query is:

<?
$query = "(SELECT spacenummer FROM res WHERE arrival BETWEEN '$var_from' AND '$var_to' OR departure BETWEEN '$var_from' and '$var_to';)";
?>
 

and the second query is

$query1 = "(SELECT spacenummer FROM spaces;)";
 

The table spaces lists all of the available spaces.
The table res lists all booked spaces and dates.

I would like to find out if in the given date range a space is available then to show it in an output and/or give either a yes or no.

Thanks in advance

If anyone can help, still in need of assistance on this one. PLZZZZZZZZZZZZZ

[ronverdonk]

I hope this query is what you are looking for. It selects all spacenummers in spaces that are not in the result set of the first select set.

SELECT * FROM spaces WHERE spacenummer NOT IN  (
   SELECT spacenummer FROM res 
   WHERE '2006-11-30' BETWEEN arrival AND departure 
   OR '2006-12-31' BETWEEN arrival AND departure
                                               );

Ronald :cool:

[cassbiz]

I hope this query is what you are looking for. It selects all spacenummers in spaces that are not in the result set of the first select set.

SELECT * FROM spaces WHERE spacenummer NOT IN  (
   SELECT spacenummer FROM res 
   WHERE '2006-11-30' BETWEEN arrival AND departure 
   OR '2006-12-31' BETWEEN arrival AND departure
                                               );

Ronald :cool:

Thank you, I will have to give it a go tomorrow for I can't see straight anymore today. Been a long one.

I will let you know of the results.

[ronverdonk]

Any results yet?

Ronald :cool: