Search from Multiple Tables

[Anon]

here's my script but it doesn't work... please help! (both tables have the exact same rows) Also, Im gonna need to search from 12 tables, so is there any way to make it more concise?
(btw, I also tried an array such as $alltables = array ("table1","table2");

$result = mysql_query("select * from $alltables....)

didn't work either.

Thanks in advance for the help!

if ($search)
{

$result = mysql_query("SELECT * FROM table1 WHERE date LIKE '%$query%' OR made LIKE '%$query%' JOIN table2 ON table1.id = table2.id", $db);

Warning on this line===>

if (mysql_num_rows($result) == '0') {
address_top();
echo "<H3>Search Records:</H3>";
echo "<font face=verdana size=2><B><CENTER><b>Sorry there are no records in our car listing by that name</b>";
echo "</CENTER></B></font>\n";

} 
else 
{ 

	while($row = mysql_fetch_array($result))
	{ 


	echo "<td bgcolor=#eeeeee><font face=verdana size=2>$row[date]</font></td>\n";
	echo "<td bgcolor=#eeeeee><font face=verdana size=2>$row[made]</font></td>\n";
	echo "<td bgcolor=#eeeeee><font face=verdana size=2>$row[model]</font></td>\n";
	echo "<td bgcolor=#eeeeee><font face=verdana size=2>$row[color]</font></td>\n";
	echo "<td bgcolor=#eeeeee><font face=verdana size=2>$row[mileage]</font></td>\n";
	echo "<td bgcolor=#eeeeee><font face=verdana size=2>$row[ownerpic]</font></td>\n";
	echo "<td bgcolor=#eeeeee><font face=verdana size=1>$row[id]</font></td></tr>\n";
	}  

}

[Anon]

Let me make my previous thread clearer:

$result = mysql_query("SELECT * FROM table1 WHERE date LIKE '%$query%' OR made LIKE '%$query%' JOIN table2 ON table1.id = table2.id", $db);

date and made are features in table 1 (also table 2, since they have the exact same features, but with different inputs)

I want to be able to find, say if my query is year2000 (for the date), all entries in table1 and table2 that contains entries that have date year2000.

Also, as I stated previously, I'll be using about 12 tables of same features so separate search codes for each one is out of the question. I'm sure there's a concise working way for this.

Someone please help.

thanks!

[Anon]

Try this.

$result = mysql_query("SELECT * FROM table1, table2 WHERE date LIKE '%$query%' OR made LIKE '%$query%' AND table1.id = table2.id", $db);

or

$result = mysql_query("SELECT * FROM table1, table2 WHERE (date LIKE '%$query%' OR made LIKE '%$query%') AND table1.id = table2.id", $db);

I had the same problem and your question helped me figure it out. The main difference between our queries was that I had all AND's and no OR's.