Database field name correction

Hi Ray,
In the attached file boats_insert.php
I noticed that a data field "Condition1" is not being entered (inserted in the table).
and on line 19 the field is named as "Condition" but the field in the table is named "Condition1"

There are a number of Condition entries and I wondered if you could tell me which
Condition(s) need changing to Condition1 in this file.

At the moment the Recordset Name is rsBoatCondition
SELECT * FROM boatcondition
The field is named Condition1

I am not sure which lines 19 2off, 81, 298, 302 need changing from
Condition to Condition1.
Can you please check is I have this correct.

Many thanks
John

I think just line 81 has to be updated to:

$InsertQuery->bindColumn("Condition1", "s", "".($_POST["Condition"]) ."", "WA_DEFAULT");

Hi Ray,

The line 91 at the moment is field that is required,
$InsertQuery->bindColumn("ContactPermission", "z", "".(isset($_POST['ContactPermission'])?$_POST['ContactPermission']:"") ."", "WA_BLANK");

so if I replace that with
$InsertQuery->bindColumn("Condition1", "s", "".($_POST["Condition"]) ."", "WA_DEFAULT");

The 'ContactPermission' field will not exist.

Maybe I am missing something?
Regards

John

Typo... I meant line 81 which is currently:

$InsertQuery->bindColumn("Condition1", "s", "".($rsBoatCondition->getColumnVal("BoatCondition")) ."", "WA_DEFAULT");

Thanks Ray,
I have not yet worked out how line this works but it seems to have corrected the error.
Many thanks
John