combine search on 2 tables

[effennel]

Is there a simpler/more compact way to code this?

The query is the same on the 2 tables:

$sql = "SELECT id FROM users_intake WHERE users_id=5 AND timeStamp LIKE '2005%'";
$result = mysql_query($sql);
$inside1 = mysql_fetch_object($result);

$sql = "SELECT id FROM users_state WHERE users_id=5 AND timeStamp LIKE '2005%'";
$result = mysql_query($sql);
$inside2 = mysql_fetch_object($result);

if (!$inside1 and !$inside2) {
echo "no";
} else {
echo "yes";
}

Thanks
FnL

 

[PHV]

Maybe something like this:
$sql = "SELECT id FROM users_intake WHERE users_id=5 AND timeStamp LIKE '2005%' UNION SELECT id FROM users_state WHERE users_id=5 AND timeStamp LIKE '2005%'";

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[effennel]

Thanks PH,

I'll post that on the MySQL forum since MySQL does not support UNION...

FnL

 

[effennel]

That is before Version 4.0.0