Re: Creating a search

[Martyn Coupland]

Simple just use this (normal search)...

SELECT * FROM `db1.table1`, `db2.table2` WHERE `field1` LIKE `%query%`

Then implement into mysql_query and loop through using the while loop for multiple returns.

For reference I suggest looking at the String Comparision section in the Documenation...

http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html