mysql_query and explode and implode

[mysterbx]

Hello,

 

How can I make this work:

 

$search = $_POST['search'];
$search2 = explode(" ", $search);
$searchname = implode("%' && title LIKE '%", $search2);
$test = "title LIKE '%$searchname%'";
$result = mysql_query("SELECT * FROM downloads WHERE $test order by id DESC limit 0,999");

 

Lets say i have these downloads in my database:

Hitman 2007

hitman movies sample 2007

hitman sample movie

cool hitmans movie 2007 year

 

if $search is hitman, it will output all 4 results,

if query is hitman 2007, it will only output one result (hitman 2007), how can I make this thing to output 3 results (hitman 2007 & hitman movies sample 2007 & cool hitmans movie 2007 year)

 

I cant figure this out...

[mysterbx]

done

 

i figured it out.. the code was ok, but mysql_query had some problems...