One Good Result
Nice Result
Result
when retrieving the values for an autocomplete when I write "result" I would like to retrieve "Result" first from the database, then any other that contains result.
Code: Select all
$termgotten="result";
$result=mysql_query("SELECT * FROM table WHERE LOWER(row) LIKE '%".mysql_real_escape_string($termgotten)."%' LIMIT 6");One Good Result
Nice Result
Result
as the results, so what would be the specification to get "result" let's say in an order of appearance - a mysql explote to order by?
Thanks