stimlict

i need a search script in which someone searches through my tables. I have 3 main tables, (news, articles, and famous diamonds) and in the drop down they need to select from which table. Then it has to beable to search... current example at the top i have is at http://www.dakov.com but the code gives me error each table has different name for the table, title, and body for example in one table title column is title and in another its titlearticle, and third its namegia i cant figure out how to query it from various tables from the database and display the results nicely [php:1:10b1238074]<?php $sql = \" SELECT *, MATCH($title, $body) AGAINST(\'$searchresult\') AS score FROM $usertable WHERE MATCH($title, $body) AGAINST(\'$searchresult\') ORDER BY score DESC \"; $rest = MySQL_query($sql); ?> SCORETITLEID# {$sql2[\'score\']}\"; echo \"{$sql2[\'title\']}\"; echo \"{$sql2[\'id\']}\"; } echo \"\"; ?>[/php:1:10b1238074] Thanks guys.