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

2001-10-01 Thread René Fournier
nt [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 5:49 PM > To: [EMAIL PROTECTED] > Subject: RE: [PHP] How to do a dynamic UPDATE SET > > > | The result: PHP updates the values of lang, record, date, what > (etc.) to > | [LITERALLY] $lang, $record, $date, et

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 single

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: column_name1 column_name2

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 = mysql_list_fields($d