Display column names and variables

[Peds]

I am trying to write an application that allows a user to submit information to a mysql table. When the user completes 7 forms, all of the information is presented on form8 and then inserted into a table (this works fine by passing variables between pages etc)

What I am having difficulty in is working out how the administrator can retrieve the data entered in the same format as displayed in form8.

I want to be able to retrieve the information based on a unique id. My table has 160 fields and i was wondering if it was possible to retrieve field name and value based on a condition without having to type all of the variables out:

ie SELECT * FROM table_name WHERE id=1234

with a result of:
$column1 = column1_value
$column2 = column2_value
etc

This way i could set the variables and echo $column1 etc in the current format of form 8

THANKS!

[devinemke]

i'm assuming "id" is your unique primary key field. let's say you want to grab everything from id #1234:

$result = mysql_query('SELECT * FROM table_name WHERE id = 1234');
$row = mysql_fetch_assoc($result)
foreach ($row as $key => $value)
{
	echo $key . ' = ' . $value . '<br>';
}

this is just a simply example that echos out the fields/values. you could easily modify this to echo into form value tags.

[drawmack]

this might give you some ideas: http://www.phpbuilder.net/board/showthread.php?s=&threadid=10278364