Results 1 to 2 of 2

Thread: MySQOl

  1. #1
    Join Date
    Jan 2004
    Location
    Notts
    Posts
    1

    Post Unanswered: MySQOl

    I am implementing a shopping cart system into Dreamweaver MX and am also using MySQL as the database. I have a Cart table where there are two attributes Productprice and Quantity. I would like to know whether there are any valid SQL queries that can multiply the product price by the quantity and output a totol price.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, there are

    they would look something like this:

    select Productprice * Quantity as TotalPrice
    from Cart

    that wasn't so hard, was it?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •