Sorry for the following non-normalised database, but i am a little desperate so this is the easiest way.
1 db- 1tbl
Now I want to search my entire db on $searchword
why doesn't the following sql-query work:
$sql = "SELECT * FROM tbl WHERE name LIKE '%$searchword%' AND city LIKE '%$searchword%' ORDER BY name OR city DESC LIMIT 0, 25";