I do this ...
$query = mysql_query("SELECT * FROM foo");
$data = mysql_fetch_assoc($query);
extract($data);
if you need all the rows from the query, do ...
$query = mysql_query("SELECT * FROM foo");
while($data = mysql_fetch_assoc($query) {
extract($data);
}
Jim
>Someone came with a very clever solution to simplify the extraction of all
>fields when doing a select * from table
>
>it's a command that passes all values from the fields on the table
>to variables
>of the same name than the field on that table. No need to program
>it manually,
>creates all variables with same names as the table fields.
>
>Could someone tell me how to do this?
>
>Alfredo
>
>
>--
>PHP General 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]
--
Jim Musil
---------
Multimedia Programmer
Nettmedia
-------------
212-629-0004
[EMAIL PROTECTED]
--
PHP General 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]
