display top 20 records using id as DESC 1

[dwlerwill]

hi all

trying to make an online php chat system and I would like to display the last 20 records I have the following

$chattext="SELECT user, chat_line FROM gamechat ORDER BY id DESC LIMIT 20 ";
$chattext2=mysql_query($chattext) or die("Could not get user stats");
$chattext3=mysql_fetch_array($chattext2);

i'm having problems displaying the results all I want is a simple 20 line display of the results but I can not get it to work with print any ideas?

David Lerwill
"If at first you don't succeed go to the pub"

 

[jpadie]

echo "<dl>";
while ($row = mysql_fetch_assoc($chattext2)):
 echo "<dt>$row['user']</dt><dd>$row['chat_line']</dd>";
endwhile;
echo "</dl>";

 

[dwlerwill]

Thank you

David Lerwill
"If at first you don't succeed go to the pub"