PHP comment box question

DEmeant0r

Ok, so I've a comment box in my website, and I'd like to limit the amount of comments the page shows, because if there's too many, it'll just **** up the site, I've tried many variations of installing a counter variable into the loop, but to no avail, so here's the PHP code:
<?php
$dbh=mysql_connect ("localhost", "blahblah", "blahbalh") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("blahblah");

$result = mysql_query("SELECT * FROM comments ORDER BY id DESC");
while($r = mysql_fetch_array($result))
{
$comment=$r["comment"];
$by=$r["by"];

echo "<strong>message:</strong><br>$comment<br><strong>Comment by: </strong>$by<br><br>";
}

mysql_close();
?>

Karoma

ORDER BY id DESC LIMIT... ?

DEmeant0r

hrmm I'll try that, hope if works... [edit] lol ok it worked, didn't know there was such an easy solution, thanks![/edit]