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";

Grtz