RE: [PHP] How to do a dynamic UPDATE SET

2001-10-01 Thread Vincent
| But here's what I want to do now: I want to use the same two | lines of code for any possible form data that might be submitted mysql_list_fields retrieves all field names of $table; with that you can build your SET-clause for the query. something like: $fields =

RE: [PHP] How to do a dynamic UPDATE SET

2001-10-01 Thread Joe Kaiping
Something like this might work for you. (Just typed in the code and didn't test it, so take with a grain of salt. It doesn't really take into account all types of data, but maybe it will help with an idea.) Have groups of the following in your form: TR TD SELECT NAME=column[] OPTION

RE: [PHP] How to do a dynamic UPDATE SET

2001-10-01 Thread Vincent
| The result: PHP updates the values of lang, record, date, what (etc.) to | [LITERALLY] $lang, $record, $date, etc--NOT the values of those fields | submitted by the form. I'm kinda lost as to what to do... Any | suggestions?? Ow yea, little mistake of mine, sorry. I think removing the

RE: [PHP] How to do a dynamic UPDATE SET

2001-10-01 Thread René Fournier
] How to do a dynamic UPDATE SET | The result: PHP updates the values of lang, record, date, what (etc.) to | [LITERALLY] $lang, $record, $date, etc--NOT the values of those fields | submitted by the form. I'm kinda lost as to what to do... Any | suggestions?? Ow yea, little mistake of mine