[PHP] Extract all fields of a table to vars of same name

2001-12-04 Thread Baloo :0\)
Someone came with a very clever solution to simplify the extraction of all fields when doing aselect * 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

Re: [PHP] Extract all fields of a table to vars of same name

2001-12-04 Thread Hank Marquardt
that would be extract() -- http://www.php.net/extract On Tue, Dec 04, 2001 at 01:09:27PM -0700, Baloo :0) wrote: Someone came with a very clever solution to simplify the extraction of all fields when doing aselect * from table it's a command that passes all values from the fields on the

Re: [PHP] Extract all fields of a table to vars of same name

2001-12-04 Thread Jim
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

[PHP] Extract all fields of a table to vars of same name

2001-12-04 Thread Baloo :0\)
Someone came with a very clever solution to simplify the extraction of all fields when doing aselect * 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