| 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 =
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
| 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
] 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
4 matches
Mail list logo