Calculation Problem

[Anon]

Using a Mysql DB I use this what you think would be simple code to muiltiple two fields

$sel_price_total = $sel_price * $sel_qty;

the problem is that if the price is 9.50 it only muiltiples the dollars and not the cents the field is use a float to hold the dollar value and an int for the qty value

can any one tell me a better way to do this.

TIA
Richie TM

[lawnmowerman]

Have you tried doing this within the DB?

SELECT price * quantity AS price_total FROM table;

This query should return a pice_total column populated by price x quantity for each row.

Hope this helps!

-Rich