Search query multiple tables? (PHP, MySQL)

Website Search Engine Series...

[alcheme]

How can I search multiple tables & databases?

Current table: directory
Additional table: list

------> Start Code

$db=mysql_connect ("localhost", "******", "*******") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("****_DBNAME",$db);

$sql= mysql_query("SELECT wname, url, title, keywords, description, city, country, category FROM directory WHERE city LIKE '%$search%' ¦¦ wname LIKE '%$search%' ¦¦ title LIKE '%$search%' ¦¦ keywords LIKE '%$search%' ¦¦ description LIKE '%$search%' ¦¦ country LIKE '%$search%' ¦¦ category LIKE '%$search%' ¦¦ url LIKE '%$search%'", $db);

------> End Code

Any ideas?

I'll post the final solution when there is one :-)

~Shane

[storevalley]

To query multiple tables, use a join [dev.mysql.com].

[alcheme]

For example... Just like this?

$sql= mysql_query("SELECT wname, url, title, keywords, description, city, country, category FROM directory WHERE city LIKE '%$search%' ¦¦ wname LIKE '%$search%' ¦¦ title LIKE '%$search%' ¦¦ keywords LIKE '%$search%' ¦¦ description LIKE '%$search%' ¦¦ country LIKE '%$search%' ¦¦ category LIKE '%$search%' ¦¦ url LIKE '%$search%' JOIN SELECT * FROM list WHERE city LIKE '%$search%'", $db);