Populating a multiple select box from a database
I have a HTML form with a multiple select box. The multiple select box is populated from a database. A user can select multiple options form this select box and the infomrtaion is then stored in a database.
The user then has the option to edit their saved record. How do i populate this multiple select box from a database with the users selected/saved options highlighted?
I can manage to get it to work if the user simply selected one option but not for multiple options. how do i iterate the record set with the saved options whilst at the same time comparing with a record set that populates the multiple select box? Sample code would be help full.