Select Drop down box not working

Hi Ray,
I have a page with some drop down select boxes.
One of the boxes Select Unit of Measurement I cannot get working, the rest seem OK

if I select from the box and try to update the page the selection goes back to the Box Label.

One other pint is within the Dynamic Selection I am not sure whether the Type selection should be set as Menu or List?
I will attach the file.
Thank you
John

You aren't inserting the value of that select list into the database. You have to open your insert record server behavior and bind the associated column to the select list form field.

Menu and list work the same way. You have that set correct if it looks how you want it to.

It also looks like you have an old version of insert on the page with the MySQLi version. I think that can be removed. Delete lines 37-111 because I don't think you are using them anymore.

Thanks Ray,
I think I carried out those items correctly but I get an error message
Access forbidden!

You don't have permission to access the requested object. It is either read-protected or not readable by the server.

If you think this is a server error, please contact the webmaster.
Error 403
localhost
Apache/2.4.29 (Win32) OpenSSL/1.0.2l PHP/5.6.32

This text was in the address bar.
http://localhost/boatsforsalenow_mysqli2/BoatAdds180Premium%20from%20BFSNow.com/%3Cbr%20/%3E%3Cb%3ENotice%3C/b%3E:%20%20Undefined%20variable:%20editFormAction%20in%20%3Cb%3EC:/xampp/htdocs/boatsforsalenow_mysqli2/BoatAdds180Premium%20from%20BFSNow.com/boats_Insert_Premium.php%3C/b%3E%20on%20line%20%3Cb%3E207%3C/b%3E%3Cbr%20/%3E

Delete the form action in your html. <form> should just have action=""

Reline 206
I now have this in the code but it shows an error at the top of the page

<td>action=""<?php echo $editFormAction; ?>

and
action=""
Notice: Undefined variable: editFormAction in C:\xampp\htdocs\boatsforsalenow_mysqli2\BoatAdds180Premium from BFSNow.com\boats_Insert_Premium.php on line 206

Delete that code. It was leftover from the old mysql insert I had you delete.

I have now progressed to the next page

Please attach the actual page when you want me to look at your code. It is much easier when I can open it in Dreamweaver.

I think you may just have to delete these lines:


<?php
$query_rsPayPal = "SELECT RecNo, RegDate, Manufacturer, Model, MyFName, MyLName FROM boats WHERE RecNo = (SELECT MAX(RecNo) FROM boats) ";
$rsPayPal = mysql_query($query_rsPayPal, $conn1_i) or die(mysql_error());
$row_rsPayPal = mysql_fetch_assoc($rsPayPal);
$rsPayPal->TotalRows = mysql_num_rows($rsPayPal);
$query_rsPayPal = "SELECT RecNo, RegDate, Manufacturer, Model FROM boats WHERE RecNo = (SELECT MAX(RecNo) FROM boats) ";
$rsPayPal = mysql_query($query_rsPayPal, $conn1_i) or die(mysql_error());
$row_rsPayPal = mysql_fetch_assoc($rsPayPal);
$rsPayPal->TotalRows = mysql_num_rows($rsPayPal);
?>

they are leftover repeats of the old Recordset. Dreamweaver can sometimes create repeated recordsets that can just be deleted and the upgrade only updated the first one.