multiple update missing 2 fields
Hi Ray
I have quite a complicated page (attached). There are 3 optional select menus on the form - the dropdowns all work.
However, only the data entered into the first (sel1) is updated in the database - the other two are ignored.
The update code at the top of the page is identical, bar the field names:
$UpdateQuery->bindColumn("fr_sel1", "s", "".((isset($_POST["sel1"."_".$MultipleUpdateCount]))?$_POST["sel1"."_".$MultipleUpdateCount]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("fr_sel2", "s", "".((isset($_POST["sel2"."_".$MultipleUpdateCount]))?$_POST["sel2"."_".$MultipleUpdateCount]:"") ."", "WA_NULL");
$UpdateQuery->bindColumn("fr_sel3", "s", "".((isset($_POST["sel3"."_".$MultipleUpdateCount]))?$_POST["sel3"."_".$MultipleUpdateCount]:"") ."", "WA_NULL");
and ditto for the form fields themselves.
Anything obvious?
Many thanks
Chris