i have a CustDetails table with attributes
ID
Username
....
and
Products table with attributes
ProdID
Prodname
....
and
cart table with attributes
cartID
ProdID
ID
i was wondering there was any way that when a user selects the add item link that the item is added to the cart table but also the ProdID and the users ID. i need an insert statement that will link the CustDetails.ID to cart.ID and Products.ProdID to cart.ProdID.
can anyone help me?
Thanx
php and mysql
Moderator: General Moderators