Admin - Assigning Product Options - Revised Help

Hi, in reference to something I have enquired about before, And after coding part of the admin area to add/update Product OPTIONGROUPS and Product OPTIONS for an online store. I just need need help on the steps connect the PRODUCTOPTIONS to a product.

I have attached an image to show what I need. I just cannot get my head around the best way of doing it.

the image is a screenshot of some options that pulled in by a URL ProductID reference.

ProductGroups are made up of either (1) text box option (2) tick box option (3) select list of options (the select list contents also differs per optiongroup). (on the example page you only see options for text box or select list) the tick boxes on the right side are additional "choices" for the ProductOptions table that is used to reference to the product.

I want the admin to add a "option group" to a product this is then displayed in the example screenshot (note: Admin can add the same OptionGroup as you can see in the screenshot).

The screenshot is based on code I have already put in place. EG to display the Options that you can see in the screenshot I used:

SELECT *
FROM productoptions LEFT JOIN optiongroups ON productoptions.OptionGroupID = optiongroups.OptionGroupID
WHERE ProductID = colname

The point of the tick box on the far left will allow the Admin to "deselect" the tickbox so that when the save button is pressed it will delete the association of that particular option from the product.

The select list that you see in the bigger box will also output the options associated with that particular optiongroup (which I had assigned on a different page to create an optiongroup. - So Im guessing I would need to hand code a recordset inside the "repeat region of the form.

Also I am guessing I would need to used an Update Multiple records as well.

But this is where I am stuck, as I cannot seem to figure out method of coding..

Could you please let me know the the method of getting this particular page to work in how I described above?

Here is an idea of my databse structure to get an idea on how it all connects:

CREATE `optiongroups` (
`OptionGroupID` int(11) NOT NULL AUTO_INCREMENT,
`OptionGroupName` varchar(50) DEFAULT NULL,
`OptionGroupType` varchar(20) NOT NULL,
PRIMARY KEY (`OptionGroupID`)

CREATE `options` (
`OptionID` int(11) NOT NULL AUTO_INCREMENT,
`OptionGroupID` int(11) DEFAULT NULL,
`OptionName` varchar(50) DEFAULT NULL,
`OptionPrice` float NOT NULL,
PRIMARY KEY (`OptionID`)

TABLE `productoptions` (
`ProductOptionID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ProductID` int(10) unsigned NOT NULL,
`OptionGroupID` int(10) unsigned NOT NULL,
`OptionIncluded` tinyint(1) NOT NULL,
`OptionRequired` tinyint(1) NOT NULL,
`OptionSort` int(3) NOT NULL,
PRIMARY KEY (`ProductOptionID`)



regards

Chris

I got most of it working (created the add Product Option) which then displays on the listing below it. Alos I created a recordset inside the loop (in the bottom box of the screenshot) and the "Price Included" and "Option Required" tick boxes show correct state stored in that record of the database).

...All I need to find out how to do, the following:

the tick box on the far left I want to show it ticked if that record belongs to the ProductOptions for that partcular product (ie ALL those options would have a "tick" state since the recordset it pulling the data by productoptions = product. HOWEVER what I would like to do is a USER can "untick" the box then once they click save it will DELETE that particular record.

to delete the unclicked options would require hand coding.

you would need to code a loop that looked at each option to see if it was included in the form post or not, if it is not included in the form post, then it was checked so delete it.

it would be easier to show a list of options that had already been set for the product, and delete the ones that _are_ checked. you could do this using a dataAssist delete multiple records behavior.

use a recordset to show all the options fro the product from the productoptions table, add a check box to the page, use the ProductOptionID as the checked value. add a repeat region around the check box, then apply the delete multiple records behavior.

Will try your method, for the time being Ive just done a simple "delete" icon to click on using a form for each record.

After posting this, I managed to get everything thing work I just need to drop in another recordset in my repeat region so that the options will display in the dropdown select list (as they are going to be all different depending which option). I thought it would be a lot harder then I was capable off, but I must have learnt some things by now as it all works, and I didnt even purchase another premier ticket for this one) :)