to use a desc, you need an order by

"Barry Rumsey" <[EMAIL PROTECTED]> wrote in 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>";}
{ while($row = mysql_fetch_array($req))

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.

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to