Why not just use an if instead of a while? This way you test for a result
and get it at the same time

If ($array = mysql_fetch_array($result))
{       foreach($array as $key=?$value) echo("$key=?$value<br>");
} else echo("sorry didn't get anything");

Tim Ward
Internet Chess www.chessish.com <http://www.chessish.com> 

        From:  Alexander Skwar [SMTP:[EMAIL PROTECTED]]
        Sent:  10 April 2002 16:50
        To:  Php-General@Lists. Php. Net
        Subject:  Re: [PHP] Is While needed in MySQL Result with a Limit of

        »Brian Drexler« sagte am 2002-04-10 um 07:58:59 -0400 :
        > My question is this....is the while statement needed when I'm only
        > one record?

        No, it's not.  Since you know that you'll either get 0 or 1 row, you
        don't need the while loop.  Instead I'd call mysql_num_rows to see
        there was 1 row.

        Alexander Skwar
        How to quote:   http://learn.to/quote (german) http://quote.6x.to
        Homepage:       http://www.iso-top.de      |     Jabber:
           iso-top.de - Die günstige Art an Linux Distributionen zu kommen
                               Uptime: 21 hours 45 minutes

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to