mysql - Multiple keywords in SELECT LIKE -

i have search function on site uses get. have been trying code take words out of post , search in using sql. been able do:

$id = $_get["search"];   $searchterms = explode(' ', $id); $searchtermbits = array(); foreach ($searchterms $term) {     $term = trim($term);     if (!empty($term)) {         $searchtermbits[] = "name '%$term%'"     } }  $lol = mysql_query("select * database .implode(' , ', $searchtermbits).") 

i don't know i'm doing wrong. following error:

 have error in sql syntax;  check manual corresponds mysql server   version right syntax use near '(' , ', array).' @ line 1 

$lol = mysql_query("select * database .implode(' , ', $searchtermbits).") 

should be

$lol = mysql_query("select * database ". implode(' , ', $searchtermbits). "")