$query = "SELECT * FROM xp_sings,xp_artist,xp_songs WHERE xp_artist.artist_id = xp_sings.artist_id AND xp_sings.song_id = xp_songs.song_id AND song_name LIKE 'b%' DESC LIMIT 5"; $req = mysql_query($query); $res = mysql_num_rows($req);
if ($res == 0) { echo "<center><b>Sorry there is no result.</b></center>";} else { while($row = mysql_fetch_array($req)) { extract($row); It returns as "Sorry there is no result" but if I leave of the DESC and limit , it works. Can someone tell me where I'm going wrong.