ss 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
1
»Brian Dre
»Brian Drexler« sagte am 2002-04-10 um 07:58:59 -0400 :
> My question is thisis 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:58 PM
Subject: [PHP] Is While needed in MySQL Result with a Limit of 1
> Here is my code:
>
> mysql_connect("localhost","username","password");
> $result=mysql_db_query("Database","select * from table_name where
> criteria=whatever limi
Here is my code:
mysql_connect("localhost","username","password");
$result=mysql_db_query("Database","select * from table_name where
criteria=whatever limit 1");
while($r=mysql_fetch_array($result) {
$Value1=$r["TableFieldName1"];
$Value2=$r["TableFieldName2"];
echo "$Valu
4 matches
Mail list logo
