Hi,

I am trying to create a suggestion box for my website.....which should must show keywords suggestions like this.....

So if I am searching a single word or a full string it should show all the related keywords as given above.

THis is what I am trying

$keyname is the variable In which I am storing keyword from user.

PHP Code:

$pieces = preg_split('/[\s&-]+/',$keyname);
$break = count($pieces);
                    if ($break==5)
                    $sql_category="select * from category where category like '$keyname%' or category like '$pieces[0] $pieces[1]%' or category like '$pieces[2]%' or category like '$pieces[3]%' or category like '$pieces[4]%' order by category LIMIT 50";
                    if ($break==4)
                    $sql_category="select * from categorywhere category like '$keyname%' or category like '$pieces[0] $pieces[1]%' or category like '$pieces[2]%' or category like '$pieces[3]%' order by category LIMIT 50";
                    if ($break==3)
                    $sql_category="select * from category where category like '$keyname%' or category like '$pieces[0] $pieces[1]%' or category like '$pieces[2]%' order by category LIMIT 50";
                    if ($break==2)

                    $sql_category="select * from category where category like '$keyname%' or category like '$pieces[0] $pieces[1]%' order by category LIMIT 50";
                   else
                    $sql_category="select * from category where category like '$keyname%' or category like '$pieces[0]%' order by category desc LIMIT 50"; 


I hope I've explained enough to get my point.

If there's something unclear please let me know.

Thanks in Advance.

I've explained a bit more.....