Using query to refer to form fields

[joejoe83]

Quick question, probably a simple answer, but it's driving me mad trying to work it out.

I have a MySQL table and a PHP form. The form executes a query, returns each entry of the table using a loop, and creates a number of inputs based on each entry.

e.g. the table contains people. The form aims to allow the user to enter the name and age of each person. The names of the fields are created by using the following syntax: '%sname' and '%sage', to give each field a unique name.

However, I am having trouble referring to these fields when updating the table in another part of the PHP code.

i.e. ...UPDATE person SET age='$%sage'... having executed the same query as mentioned above to loop through all the people.

I assume the problem lies in the syntax of concatenating the names of the fields in the form, and the results of the second query.

Any ideas would be MOST welcome!

😕

[joejoe83]

Thanks for the reply.

Pardon my ignorance but I am struggling to see how the code you suggested would apply.

"UPDATE table SET field WHERE field LIKE '%stuff' LIMIT 0,1"

Just to reiterate, for each entry of the table, two form fields are created using their primary key to create unique field names. e.g. for a record for john, the fields on the form created would be johnage and johnsurname, created using '%sage' and '%ssurname'.

I then want to use these fields on the form to update the table in MySQL. To refer to these form fields, I run the same loop as before, but am having trouble recreating the field names.

Could you possibly explain what your example is doing?

Thanks!