Is this Mysql query possible

[brian calloway]

Hello everyone... I'm new here....

Ok I have a shopping cart and some products have options.

The mysql query reads like this:
$result = mysql_query("select count(*) from My_cart where cookieIdnum = '" . GetCartId() . "' and itemIdnum = $itemIdnum");

it checks the cookieIdnum just to keep track of the customer and what they add to the cart, and the itemIdnum is the id of the product.

If the customer tries to add the same product it won't let them just says update quanity because it checks a reads the same item ID.

How would I write a mysql query that will allow for the customer to add the same product but with a different option???


Any help would be great!
Thanks