mysql_result()
| From: | Jordan Elver | Date: | Wed, 04 Apr 2001 15:45:58 +0000 |
| Subject: | mysql_result() | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-8211@lists.php.net to get a copy of this message | ||
Hi,
If I knnow that a query will only retrun one row, can I do thiss (below)
rather than using a while loop for one record?
$id = @mysql_result($result, 0, 'id');
$name = @mysql_result($result, 0, 'name');
$email = @mysql_result($result, 0, 'email');
$address1 = @mysql_result($result, 0, 'address1');
$address2 = @mysql_result($result, 0, 'address2');
$town_city = @mysql_result($result, 0, 'town_city');
$postcode = @mysql_result($result, 0, 'postcode');
Cheers,
Jord