Re: Shortcut for MySQL $variable = $row["variable"];?

On Fri, 06 Oct 2000, Erica Douglass wrote: > Hello, > > Is there any kind of loop structure to tell PHP to make a variable for > every row item returned from MySQL, instead of having to do this: > > while ($row = mysql_fetch_array ($result)) { > $variable = $row["variable"]; > $variable2 = $row["variable2"]; > # etc, etc, for EVERY item... > }; > > I'd rather not make constants by using define(). > > Erica PHP can do _anything_! You want extract while ($row = mysql_fetch_array ($result)) { extract($row); and now all the field names are available as variables. -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA