php/mysql shopping cart

[imbizsol]

I recently created a shopping cart script using PHP and MySQL. I have the following fields in my database:

itemid
title
desc
color
price

I want to add options to each item though, except each option costs an extra amount.

For instance, one of the options might be to be laminated for an extra $2.50.

I want to be able to let the customer select the option and have the option's extra price be added to their amount.

My question is this:

Do I need to add the options and option prices to my product database and then somehow add that into my cart script, or can I add the options into my form fields (maybe as a hidden field) and have the script somehow add the extra price from the form?

Hope that makes sense.

Any help/advice you can give would be greatly appreciated.

Thanks in advance.

M.

[bastien]

and then created a field in the product table to store all the possible items that could be options...so:

products_table
productID
productName
productOptions //holds an array of options(all options possible for each product, some may have none and other many

options_table
optionID
optionName
optionPrice
optionDescription

hth