Is While needed in MySQL Result with a Limit of 1
| From: | Brian Drexler | Date: | Wed, 10 Apr 2002 11:58:59 +0000 |
| Subject: | Is While needed in MySQL Result with a Limit of 1 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-92372@lists.php.net to get a copy of this message | ||
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 this....is the while statement needed when I'm only returning
one record?
Brian