[PHP-DB] search query problem

hi i am making a simple search form how can i search more than one table for the same word i used a query and it failed here it is @ $db = mysql_connect("localhost");mysql_select_db("egycds"); $test_tr = mysql_query("select newdvd.date, newpcgames.date, olddvd.date,

[PHP-DB] search query problem

hi i am making a simple search form how can i search more than one table for the same word i used a query and it failed here it is @ $db = mysql_connect(localhost); mysql_select_db(egycds); $test_tr = mysql_query(select newdvd.date, newpcgames.date, olddvd.date, screener.date, newdvd.type,