Re: Help Please

SpiderWebb wrote:

From: "SpiderWebb" <spiderwebb@ec-sys.com> Subject: Help nedded Date: 09 December 2002 16:46 I dont know if this is possible in PHP (Newbie) im working on a project where each product has 3 diffierent prices depending on the amount sold so say for example 1- 100 price A 101-299 price B and above 300 Price C. What I need to be able to do is increment an mysql database field each time an item is sold then look at that field to decide which price variable to write to the price field of the database. Could someone point me in the right direction where I could solve this or to someone who could Thanks in advance. Spiderwebb

This seems a matter of database design. For simple solution, use COUNT in SQL. But having a record for each item would probably exceed the limit of either harddisc or database one day. -- BABA Yoshihiko