Field Name and value

[craygo]

I have a table with about 40 fields What I want to do is loop thru the field names and values and print them to the screen edit them.

So i have a row with id#2, I want to return each field name and the value for that field name in a loop.

Ray

[Barand]

if you use

[code]$row = mysql_fetch_assoc($result);[/code]

then $row is an array of field values whose key is the field name

[code]foreach ($row as $fname => $value) {

        echo "$fname : $value<br>";

}[/code]