Two ways:
Do it in PHP
add a counter and test for it at the end of the while loop
if ==20 then break;
Easier, do it in your query:
tack LIMIT 20 on the end of your query, and you will only get the first
20 hits from your database.
On 4/2/01 3:54 PM, "Bob Stone" <[EMAIL PROTECTED]> wrote:
> Dear PHP Helpers,
>
> What is your recommendation on limiting a while
> statement so that it only iterates a maximum of 20
> times?
>
> Here is the code snippet:
>
> $result = mysql_query($sql, $db);
>
> while ($myrow = mysql_fetch_array($result)) {
>
> printf("Name: <b><font color=\"green\" size=\"5s\">%s
> %s %s %s\n<br></b></font>", $myrow["salutation"],
> $myrow["first_name"], $myrow["mid_name"],
> $myrow["user_name"]);
>
> Best regards,
>
> Bob Stone
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/?.refer=text
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
