exploding _POST for a query

[squiblo]

My query searches for people in the database.

 

If the user searches "bob" it with output "bob marley".

If the user searches "marley" it will output "bob marley" also.

 

If the user searches "bob marley" nothing will be outputted

 

how can i explode this...

$search = $_POST['search_friend'];

 

to make this query work properly...

$search_name_check = mysql_query("SELECT * FROM page_set_data WHERE forname='$search' OR surname='$search'");

 

Thanks

[squiblo]

:confused:

[wildteen88]

Use explode with a space as the first parameter. Example

list($search_forname, $search_surname) = explode(' ', $_POST['search_friend']);