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.

yes, there are

they would look something like this:

select Productprice * Quantity as TotalPrice
from Cart

that wasn't so hard, was it?