query help

[steviez]

Hi,

 

I have a number of search option on my search form and some are from table one and some from table two.

 

How do i join the following query so that if someone searches for something that is on table one it will return that value?

 

$res = mysql_query("SELECT * FROM table 1, table 2 WHERE user_privacy_search = '0' AND " . implode(' AND ', $whereClauses) . "LIMIT $from, $max_results");

[GingerRobot]

1.) I'm not really sure what you're asking.

 

2.) I suggest you do this so you can debug your query:

$sql = "SELECT * FROM table 1, table 2 WHERE user_privacy_search = '0' AND " . implode(' AND ', $whereClauses) . "LIMIT $from, $max_results";
$res = mysql_query($sql) or trigger_error(mysql_error());
echo 'Query was: '.$sql;