Search result problem

[vinpkl]

hi all

 

i m showing search result according to query.

 

$pnm=$row['product_name'];
$pnm = explode(' ', $pnm); 		

$qryc="select * from product_table where product_name LIKE '%$pnm[0]%' AND product_name LIKE '%$pnm[1]%' and category_id=4";

 

Now if somebody enters "Sony Ericsson T707" then it fetches "Sony Ericsson" as two separate words.

 

I want that it should fetch "sony Ericsson" as one word like "SonyEricsson" removing their inbetween space.

 

how can i do it.

 

vineet

[ignace]

$pnm = implode('', $pnm);

[vinpkl]

$pnm = implode('', $pnm);

 

hi ignace

 

Like the search term is "Sony Ericsson T707". By using your implode code the search term become "SonyEricssonT707".

 

I want the term to become "SonyEricsson T707".

 

I want to implode only first two words, not all.

 

vineet

[ignace]

$firstword = array_shift($pnm);
$secondword = array_shift($pnm);
$pnm = implode('', array($firstword, $secondword)) . ' ' . implode(' ', $pnm);

[vinpkl]

$firstword = array_shift($pnm);
$secondword = array_shift($pnm);
$pnm = implode('', array($firstword, $secondword)) . ' ' . implode(' ', $pnm);

 

hi ignace

 

i didnt know anything about array_shift().

 

thanks. now its fine.

 

vineet