Try this:
list($field1, $field2, $field3) = mysql_fetch_array($result);
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
yea, you can use the same code that you are just take out the while loop I
do it all the time.
Thank you
Brian Paulson
Sr. Web Developer
[EMAIL PROTECTED]
http://www.chieftain.com
1-800-269-6397
-Original Message-
From: olinux [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 10
Hi
> OK, if I am extracting a row from a mysql DB where I know
> that there is only ONE row:
>
> $result = "SELECT company, fname, lname FROM table_name WHERE
> id = \"$id\"
> ";
> So my question, shouldn't I be able to use the variables
> $company $fname $lname before the WHILE loop since I
