close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Select Drop down box not working

Thread began 3/19/2020 6:21 am by john70964 | Last modified 3/20/2020 10:28 am by Ray Borduin | 105 views | 7 replies |

john70964

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

john70964

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

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post
Did this help? Tips are appreciated...

john70964

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

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post
Did this help? Tips are appreciated...

john70964

I have now progressed to the next page

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...