Jumping Rabbit Posted April 10, 2005 Share Posted April 10, 2005 Sawadee kah, My name is Jenny and i am trying to add some additional info into the shopping cart db, i would like to add category id in addition to the product id. I have added the new field to the db, and i do know how to catch the cat id nr. My current problem is how to sucessfully add it to the buy button form and then into the new db table. Any help or points in the right direction is greately appriciated. Faster Checkout - osCommerce Knowledge Base - Anyone meet offline?, Has anyone of you cyberkids meet offline? For newbees do atleast read this 4 points: Basic info - Search tips and help - Posting tips and help - Basics for Design Link to comment Share on other sites More sharing options...
boxtel Posted April 10, 2005 Share Posted April 10, 2005 Sawadee kah, My name is Jenny and i am trying to add some additional info into the shopping cart db, i would like to add category id in addition to the product id. I have added the new field to the db, and i do know how to catch the cat id nr. My current problem is how to sucessfully add it to the buy button form and then into the new db table. Any help or points in the right direction is greately appriciated. <{POST_SNAPBACK}> why would you want to store this redundant information ? You can always derive the category id from the product id unless you copy products by link to multiple categories ? Treasurer MFC Link to comment Share on other sites More sharing options...
Jumping Rabbit Posted April 10, 2005 Author Share Posted April 10, 2005 Hi Amanda, Thanks for taking an interest, by the way you seem to be quite close, geographicaly that is :D I will use it for price differantiation, based on customer groups and category id. Faster Checkout - osCommerce Knowledge Base - Anyone meet offline?, Has anyone of you cyberkids meet offline? For newbees do atleast read this 4 points: Basic info - Search tips and help - Posting tips and help - Basics for Design Link to comment Share on other sites More sharing options...
boxtel Posted April 10, 2005 Share Posted April 10, 2005 Hi Amanda, Thanks for taking an interest, by the way you seem to be quite close, geographicaly that is :D I will use it for price differantiation, based on customer groups and category id. <{POST_SNAPBACK}> ok, well, normally, the cart is only stored in the DB for registered customers. That content is then merged with the session cart if they login again. Guests cart info will not be stored in the DB but remains only in the session variable $cart. so I would add the variables to the shopping cart class. But still, (unless you copy products as a link to multiple categories), if you need to get the category id for a specific products id, you can simply derive it from the products_to_categories table, there the relation is recorded and as such no additional storing is required. Treasurer MFC Link to comment Share on other sites More sharing options...
Jumping Rabbit Posted April 10, 2005 Author Share Posted April 10, 2005 Thanks Amanda, i will look through and implement it in the shopping cart class if possible.... Bringing happiness to a stranger will cosmicaly multiply and bring you a thousandfold in return. Sorry, about the broken up english, its not my mother tongue. I will scurge the forum and try to help atleast 5 persons today, and wait for a heavenly reward :lol: Faster Checkout - osCommerce Knowledge Base - Anyone meet offline?, Has anyone of you cyberkids meet offline? For newbees do atleast read this 4 points: Basic info - Search tips and help - Posting tips and help - Basics for Design Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.