PHP Mysql Search Help

Hello,
I am building a search function for my website and wish for it to now be able to search two rows (if possible) ??

Im running a DVD site and my search box currently searches through the 'names' row for whatever keyword was searched for.

I need it to search in both the 'names' and 'summary' rows to return the result.

$result = mysql_query("SELECT * FROM DVDs WHERE name LIKE '%$search%'");

//grab all the content
while($r=mysql_fetch_array($result))
{

$name=$r["name"];
$summary=$r["summary"];
$price=$r["price"];
$category=$r["category"];
$id=$r["id"];
$pic = $r["pic"];

//display the row

Any help would be greatly appreciated

Regards
Adam

hi!
not really sure i got your point... but do you want something like this

$result = mysql_query("SELECT * FROM DVDs WHERE name LIKE '%$name_search%' OR summary LIKE '%$summary_search%'");

of course you first have to check then if one of the search terms is empty. otherwise you will get all entries..

Thanks, it works a treat 🙂