Hi there, can someone help me adjust this while loop at all. I want to only display 20 posts at a time from the news table in my database

PHP Code:

<?php

$sql =mysql_query("SELECT * FROM news WHERE sentinfo = curdate() ORDER BY senttime DESC");



while($row = mysql_fetch_array($sql))
{

   

echo "<td <strong>" . $row['username'] . "</td>";
print ": </strong>";
echo "&nbsp";
echo  "<td>" . $row['comment'] . "</td>" ;
print "<br>";
print "<i>posted at </i>";
echo "<td>" . $row['senttime'] . "</td>";
print "<br>";
print "<br>";

}

?>

So i want to limit the loop to only ever display 20 posts...anyone adjust it to help with that?

thank alot

At the end of your query add LIMIT 20

PHP Code:


<?php

$sql = mysql_query('SELECT * FROM news WHERE sentinfo = curdate() ORDER BY senttime DESC LIMIT 20');

while($row = mysql_fetch_assoc($sql))
{
echo '<td><strong>'. $row['username'] .':</strong></td>
<td>' . $row['comment'] . '</td>
<br />
<em>posted at </em>
<td>' . $row['senttime'] . '</td>
<br />
<br />';
}

?>

Also i fixed a few tags in your coding.