Combining two SELECT queries

The_Chancer

Is it possible to combine the following to one statement ?

$result = do_query("SELECT * FROM enquiry WHERE orighotelid='$hotel' AND date_taken!<'$start' AND date_taken!>'$end' ORDER BY ref DESC");

$res=do_query("SELECT * FROM enquiry WHERE orighotelid='$hotel' AND lastupdate!<'$start' AND lastupdate!>'$end' ORDER BY ref DESC");

Unfortunately this isn't my strong point - so any help would be appreciated..

Cheers,

mattr

What is ! doing on the end? That is non-standard SQL!!

Why not just do:

WHERE orighotelid = '$hotel' 
  AND ( lastupdate < '$start' AND lastupdate > '$end' 
     OR date_taken < '$start' AND date_taken > '$end' )

The_Chancer

True, yet without it the query doesn't work... unethical, yet it works.
The new statement you gave is almost the opposite as written in english....

lastupdate is less than start (should be NOT less than start - ie equal to or greater than) etc and the same for the rest.

I have got

WHERE (orighotelid='$hotel' AND date_taken!<'$start' AND date_taken!>'$end' AND lastupdate!>$end) OR (lastupdate!<$start AND lastupdate!>$end AND orighotelid='$hotel') ORDER BY ref DESC

to work though and it does exactly what I want. Messy maybe, but not bad all the same.

Should I be using <= instead ? (need to know to improve...)

mattr

Ok try this:

WHERE orighotelid = '$hotel' 
  AND ( ( lastupdate >= '$start' AND lastupdate <= '$end' )
     OR ( date_taken >= '$start' AND date_taken <= '$end' ) )