I have a MySQL table with two fields, which basically stores field_name & field_value.
it is basically a kind of history of previously used values in a perticular form. This table is used to re-use these values while filling out form.
The table structure is like this
Code: Select all
-----------------------------------------------
Table Name : fld_data
-----------------------------------------------
field_name | field_value
--------------------|--------------------------
name | Johny Bravo
name | Freddy Dead
name | Jack Ripper
age | 15 yrs
age | 35 yrs
location | india
location | england
location | Mars
age | 50
-----------------------------------------------Now what I want to do is creating a page where user can edit / delete, values in this table.
I am stuck on how can I output the form that can edit this data, that is
I want to create a list of field_name.
something like this, say currently I have name, age, location in my table. so the list will be
not like this...name
age
location
name
name
name
age
age
location
location
location
age
so the million dollar question is How?.
Can anyone please guide me how can I achieve this ?