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]