DESC & LIMIT
| From: | Barry Rumsey | Date: | Mon, 07 Jan 2002 23:55:38 +0000 |
| Subject: | DESC & LIMIT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15516@lists.php.net to get a copy of this message | ||
$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.