[PHP-DB] Column names into variables

2006-07-26 Thread z
Hi, I have a table with about 50 columns in it. I'd like to query the information for one record, and hold the data in variables that have the same name as the column headings, along these lines: $query = Select * from `postings` where `id` = $userid; $result = mysql_query($query);

Re: [PHP-DB] Column names into variables

2006-07-26 Thread Ben Hatfield
I believe this does exactly what you want. http://us3.php.net/extract Ben Hatfield Programmer [EMAIL PROTECTED] Soapbox Studio, Inc. 469 N. Lake Street Mundelein, IL 60060 P: +1.847.566.0666 x6# www.soapboxstudio.com On Jul 26, 2006, at 12:14 pm, z wrote: Hi, I have a table with about 50