[solved] Formatting output this way !! HOW ???
Posted: Mon Dec 22, 2003 6:50 am
This is a scenario .......
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
Now name, age and location are form fields. User has facility to store whatever data he is entering in form to this perticular table (fld_data), and insert any previously used valued from DB, so that there is no need to type same values everytime.
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
so the million dollar question is How?.
Can anyone please guide me how can I achieve this ?
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 ?