search script

[tazgalsinh]

what is the best way to do a search script to search tables in my site. are they any good tutrials on the net for this? anyhelp will be great. thanks

[pablodelapena]

you could use something like this

$query = "SELECT * FROM table_name WHERE searched_column LIKE '%$search_keyword%'";
$result = mysql_query($query);

I thnk that ahs been done right, something along those lines anyway, look it up on www.mysql.com

hope that helps!!!

[tazgalsinh]

how do u search multiple tables and columns?