Looping SQL query

[Anon]

I'm trying to write an admin script for a site and I want the script to be as generic as possible. On the first page, it provides a blank text box named value1, value2, value3, etc. until their are as many text boxes as there are columns. How can I create a looping SQL statement in PHP that places these values in the order (value1,'value2','value3') etc. Also, the script has to see whether the value is a data or number and in that case it does not put '' around it. Thank you in advance for your help. This problem has stumped me for the last day or so.

[jeremy_brooks]

I'm a bit confused...do you mean inputs data into the text fields in the order of the database, or creates the text boxes dynamically in the correct order?

[Anon]

Each text box on the first page corresponds to the column name however they are named value1, value2, etc. I want them to insert into the database on the second page like
INSERT INTO $table (productid, name, etc) values (value1,'value2', etc) however i cant get it to look properly as value1, etc.

[jeremy_brooks]

Per this information taken in direct context:

1. did you prepend the variable names with a $ ?

2. did you surround your value variables with single quotes?

Or did I misunderstand you...?