$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 centerbSorry there is no
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
