I have a script which make a live search through a javascript, and it works fine besides one problem:
When a user write a letter, lets say "c" it lists all words with a c in it... I want it to only list all words starting with a c, and if he then writes "co" the only words starting with "co"... Here is my query:
$sql="SELECT * FROM ".$prefix."_categories WHERE name LIKE '%$q%' ORDER BY name ASC"
Please help...
