Interesting Problem

[accurax]

Hi guys, I wonder if someone can point me in the right direction?

I need to run a small sql query and insert some data into a custom table in my databsase, this is easy enough... but, i need to do it at the point a product is added to the shopping basket...

1. customer goes to product page and selects attributes
2. Customer clicks "add to cart"
3. My sql query runs and adds the data i need to my table
4. customer arrives at shopping basket page

I onoy want to run this code when a product is added, and im struggling to decide where to put it.

Can anyone give me any recomendations?

Thanks in advance for your replies which im sure will be very helpfull and not vague at all ;)

[Absolute]

Have a look at the shopping_Cart.php class. You'll find the data is added to the customers_basket table everytime the basket is updated, and your code should probably go in the same place. If it is only for specific products, you would need to check at this point if the product ID was one you wanted. You may also want to check if the customer already has this item in the basket, or how many times they have added it to the cart in this session. Not sure of teh reasons for your wanting to add this code, but if it is user tracking, and the customer is adding something with attributes, and keeps changing thier mind, might be a little check you want to make....

Absolute