[PHP-DB] Help nedded

2002-12-10 Thread SpiderWebb
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

Re: [PHP-DB] Help nedded

2002-12-10 Thread Mark
You might read the database to see how many have been sold previously and put that into a PHP variable. Add the amount that you'd be incrementing it by (I assume it's possible that it will increment by more than one at a time), determine the price point, and then update the row with both the new