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

[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 this....is 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