RE: [PHP] Is While needed in MySQL Result with a Limit of 1
| From: | Tim Ward | Date: | Thu, 11 Apr 2002 09:07:49 +0000 |
| Subject: | RE: [PHP] Is While needed in MySQL Result with a Limit of 1 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-92532@lists.php.net to get a copy of this message | ||
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:lists.ASkwar@DigitalProjects.com]
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
1
»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
returning
> 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
if
there was 1 row.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to
(english)
Homepage: http://www.iso-top.de | Jabber:
askwar@charente.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 21 hours 45 minutes