Thanks will try, Ill keep you all posted
"David Eisenhart" <[EMAIL PROTECTED]> wrote in message
> I can think of a couple of ways to tackle this:
> 1) The purest way is to do with your database design - a typical order
> processing database will contain a table for products, a table for
> customers, a table for orders, a table for order lines and so on ... If
> is implemented correctly (ie the tables are correct) you should be able to
> do an grouping and aggregate type query on the order line table that will
> return the number of any particular product sold and from there you can
> apply the correct price. You'll need to understand relational database
> design to do this yourself (a v good topic to know if you're doing much in
> the way of database backed sites anyway). The O'Reilly Book Web Database
> Design with Php and MySQL uses a wine order processing application as a
> running example throughout (although this appears to be principally about
> using Php with MySQL rather than database design itself it may be worth
> checking out)
> 2) More along the lines of your suggestion below you can use the MySQL '+'
> operator .Every time you sell an item you can run an update query which
> something like:-
> UPDATE table_name SET num_of_items_sold_field= (num_of_items_sold_field +
> WHERE product_id_field = the_product_id
> You can then use the value in 'num_of_items_sold_field' to determine
> price.
> You may want to check out the MySQL list as the issue appears to be
> principally a database rather than a php one.
> If at all possible I would advocate the first approach - a properly
> database will generally always pay divis in the long run.
> Hope that this helps.
> David Eisenhart
> "Spiderwebb" <[EMAIL PROTECTED]> wrote in message
> > From: "SpiderWebb" <[EMAIL PROTECTED]>
> > 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
> > 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
> > 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
> >
> >
> >
> >

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to