[PHP] Is While needed in MySQL Result with a Limit of 1

2002-04-10 Thread Brian Drexler 

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 $Value1, $Value2;
}

My question is thisis the while statement needed when I'm only returning
one record?

Brian


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

Re: [PHP] Is While needed in MySQL Result with a Limit of 1

2002-04-10 Thread Luke van Blerk 

No its not.

mysql_fetch_array will return an array if a record is found or false if not.

Regards
Luke

- Original Message -
From: Brian Drexler [EMAIL PROTECTED]
To: Php-General@Lists. Php. Net [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 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 limit 1);
 while($r=mysql_fetch_array($result) {
 $Value1=$r[TableFieldName1];
 $Value2=$r[TableFieldName2];
 echo $Value1, $Value2;
 }

 My question is thisis the while statement needed when I'm only
returning
 one record?

 Brian


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



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