RE: [PHP] retrieve single field from database without while loop
| From: | Jay Blanchard | Date: | Wed, 16 Feb 2005 12:30:29 +0000 |
| Subject: | RE: [PHP] retrieve single field from database without while loop | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-208821@lists.php.net to get a copy of this message | ||
[snip]
Is there a way to retrieve and display a single value (customer number)
from
a database and display it without using
while ($row = mysql_fetch_array) ($result)){
I have a value I know the query will only ever return a single value. I
want
to get it from the database and convert it to a variable so I can use it
on
my php page.
[/snip]
Yes...take out the while....
$row = mysql_fetch_array($results);
echo $row['CustomerNumber'] . '\n';