LIMIT?

[Independent]

How do you make PHP show only 20 of the newest fields on the page, but still able to check which username the comment is for, the current code is;



if($_POST[comment]) {
$message = silence($_POST['little']);
mysql_query("INSERT INTO comments (`from`, `for`, `message`, `date`) VALUES('$nivusr', '$propername', '$message', '$time')") or die(mysql_error());
print("<br /><br /><b>Your comment has been added.. please wait a couple of seconds!</b><meta http-equiv=\"refresh\" content=\"1\"/>");
}
}
else {
while($showcomments = mysql_fetch_array($commentcheck)) {

$commentfrom = ($showcomments['from']);
$commentmessage = ($showcomments['message']);
$commentdate = ($showcomments['date']);

$getmyfriendsimg = mysql_query("SELECT * FROM profile WHERE `name` = '$commentfrom' ORDER BY `id`");
while($showmyfriendsimg = mysql_fetch_array($getmyfriendsimg)) {

$shiwmymatesava = ($showmyfriendsimg['myimg']);
$shiwmymatename = ($showmyfriendsimg['name']);

echo('<table width="800" border="0" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td valign="top" width="50" height="1"><a href="http://www.nivade.com/profile/'.$commentfrom.'"><img border="0" img width="50" height="50" src="'.$shiwmymatesava.'"></a></td>
<td valign="top" width="700" height="12"><a href="http://www.nivade.com/profile/'.$commentfrom.'">'.$commentfrom.'</a></b><br /><font color="'.$fontcolor.'" face="'.$font.'">'.$commentmessage.'<br /></td>
</tr>
</table><br />');
}

[Protege]

"LIMIT 0, 20" In the mysqlQuery, and you need to paste the whole page as I can't under some of it, well most of it cause its so badly coded but yeah...

You could limit like this, but this is a dumb way


while ( $your_mum <= 20 )
{
$your_mum++;
$comment = $mysqlFetch[ 'comment' ];
$comment_name = $mysqlFetch[ 'name' ];
}
echo( 'Just echoed 20 of your_mums_so_fit comments' );