Barry,
Try ORDER BY song_name DESC
and then add a LIMIT.
Simply saying DESC is ambiguous as you are selecting all fields.
Miles
On Monday 07 January 2002 07:55 pm, Barry Rumsey wrote:
> $query = "SELECT * FROM xp_sings,xp_artist,xp_songs WHERE
> xp_artist.artist_id = xp_sings.artist_id AND xp_
$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 "Sorry there is no result.";}
else
{