Re: [PHP] Shipping problem...
hehe I meant to say BUG ;) > That sounds like the best idea to me, whats the big you had? > > Tim > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Custom Programming > Web Programming community & discussion > http://www.inter-apps.com > > > > - Original Message - > From: "Steve Jackson" <[EMAIL PROTECTED]> > To: "PHP General" <[EMAIL PROTECTED]> > Sent: Tuesday, October 15, 2002 2:35 AM > Subject: [PHP] Shipping problem... > > > > Hi all, > > > > I have a problem which I'm not sure the best way to go about. We will be > > shipping products based on weight and I have two types of product with > > differing weights. Basically we want to charge one price for shipping > > less than 10 KG and one for anything over that. > > > > I wonder how to go about it. I have the weights for each product and > > have my products organised into two categories in MySQL DB. So anything > > in category 1 means less than 30 items is below 10 Kilos and 15 in > > category 2. > > How would you code this? I have tried adding a weight category to my > > products table and calculating total weight (then a simple if statement > > would do the trick) but it leads to other problems which I couldn't > > de-bug. Basically adding to my products table means my DB won't update > > due to a Mysql error (column count didn't match or something) so I can't > > do it that way or at least as my shop is currently working I'm scared of > > messing with the code too much! I also need to have a combination of the > > two products so the customer might buy 1 of category 2 and 35 of cat 1 > > etc. > > > > Ideas to tackle this please? > > > > Steve Jackson > > Web Developer > > Viola Systems Ltd. > > http://www.violasystems.com > > [EMAIL PROTECTED] > > Mobile +358 50 343 5159 > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Shipping problem...
> I have tried adding a weight category to my > products table and calculating total weight (then a simple if statement > would do the trick) but it leads to other problems which I couldn't > de-bug. That sounds like the best idea to me, whats the big you had? Tim =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Custom Programming Web Programming community & discussion http://www.inter-apps.com - Original Message - From: "Steve Jackson" <[EMAIL PROTECTED]> To: "PHP General" <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 2:35 AM Subject: [PHP] Shipping problem... > Hi all, > > I have a problem which I'm not sure the best way to go about. We will be > shipping products based on weight and I have two types of product with > differing weights. Basically we want to charge one price for shipping > less than 10 KG and one for anything over that. > > I wonder how to go about it. I have the weights for each product and > have my products organised into two categories in MySQL DB. So anything > in category 1 means less than 30 items is below 10 Kilos and 15 in > category 2. > How would you code this? I have tried adding a weight category to my > products table and calculating total weight (then a simple if statement > would do the trick) but it leads to other problems which I couldn't > de-bug. Basically adding to my products table means my DB won't update > due to a Mysql error (column count didn't match or something) so I can't > do it that way or at least as my shop is currently working I'm scared of > messing with the code too much! I also need to have a combination of the > two products so the customer might buy 1 of category 2 and 35 of cat 1 > etc. > > Ideas to tackle this please? > > Steve Jackson > Web Developer > Viola Systems Ltd. > http://www.violasystems.com > [EMAIL PROTECTED] > Mobile +358 50 343 5159 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Shipping problem...
On Tuesday 15 October 2002 15:35, Steve Jackson wrote: > Hi all, > > I have a problem which I'm not sure the best way to go about. We will be > shipping products based on weight and I have two types of product with > differing weights. Basically we want to charge one price for shipping > less than 10 KG and one for anything over that. > > I wonder how to go about it. I have the weights for each product and > have my products organised into two categories in MySQL DB. So anything > in category 1 means less than 30 items is below 10 Kilos and 15 in > category 2. Perhaps I don't understand you properly -- why you need two categories? How is shipping charge calculated? Do you just have two rates (which your 1st paragraph seems to imply) -- ie If the total weight of products is under 10KG charge $5, otherwise charge $10? ... > How would you code this? I have tried adding a weight category to my > products table and calculating total weight (then a simple if statement > would do the trick) ... In which case, yes a simple if statement would suffice. > but it leads to other problems which I couldn't > de-bug. Basically adding to my products table means my DB won't update > due to a Mysql error (column count didn't match or something) Perhaps if you post your code and your db schema here then someone may be able to help. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* "God is a comedian playing to an audience too afraid to laugh." - Voltaire */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php