powers - 2004-06-11

I've managed to get my combo boxes to retrieve data from multiple tables onto a form that i use to insert records.

My problem is that i cannot insert any records now! The values from the combo boxes don't even appear in the confirmation page after clicking on submit.

Here's one of my combo box codes:

<tr height=30 valign=top>
<td align=right><b>Engineer Surname :</b></td>
<td>
    <select name="fk_engineer_idField:">
        <option value="1" selected>SELECT ONE</option>
        <?

        $querydrop = "select pk_engineer_id, engineer_surname from Engineer ORDER by engineer_surname";
        $resultdrop = MYSQL_QUERY($querydrop);
        $numberdrop = mysql_Numrows($resultdrop);

        if ($numberdrop>0)
        {

        $xdrop=0;

                while ($xdrop<$numberdrop)
                {

                $fk_engineer_id = mysql_result($resultdrop,$xdrop,"engineer_surname");
                        echo "<option value=\&quot;$fk_engineer_id\&quot;>$fk_engineer_id</option>";
                $xdrop++;
                } // end while
        } // end if

        ?>

    </select>

My insert query:

$query="insert into Job (pk_job_id,fk_engineer_id,date,symptom,fk_service_code,fk_product_type_code,fk_manufacturer_code,model,serial_number,accessories,condition,comments,fk_location_code,fk_customer_id,collection_date) VALUES ('','". $_POST['$fk_engineer_idField'] . "',Now(),'$symptomField','". $_POST['$fk_service_codeField'] . "','". $_POST['$fk_product_type_codeField'] . "','". $_POST['$fk_manufacturer_codeField'] . "','$modelField','$serial_numberField','$accessoriesField','$conditionField','$commentsField','". $_POST['$fk_location_codeField'] . "','". $_POST['$fk_customer_idField'] . "','$collection_dateField')";

Thanx