Hi guys. I really shouldn't be messin' with this stuff at my level of knowledge, but ... I'm trying to round the following query result to 2 dec places. Typical output is currently 8.14000002 and I'm after £8.14

Here's my code so far - hope it's not too bad!

$connection = mysql_connect($host,$user,$password) or die("Could not connect: ".mysql_error());
mysql_select_db($database,$connection) or die("Error in selecting the database:".mysql_error());

$query = "SELECT SUM(product_price)/100*10 FROM ps_order_detail WHERE product_supplier_reference = 'test-sch-ch-hood-2011' or product_supplier_reference = 'test-sch-girl-blazer-2011'"; //add supplier references

$result = mysql_query($query) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($result)){
echo "Total cash back to school so far £ ". $row['SUM(product_price)/100*10'];
echo "<br />";

}

?>

may i suggest using the ROUND function

Hi, thanks ..

I've tried: SELECT ROUND(SUM(product_price)/100*10,2)...
in the query but that just breaks the 'print out result'. I get £ ....
Do I have to alter that section also?

Are you sure you wanted to divide by 1000?

he's dividing by 10, teddy

dividing by 1000 would be foo/(100*10)

millers, you should use a column alias in your query, it will make displaying the result simpler

I admit I'm a complete novice. That's why I'm here looking for help. This is a bit of a one-off for me and I'm not planning on becoming an expert. I've looked at the documentation, but just can't seem to get the syntax right.

And, no! I don't want to divide by 1000 - I thought I was taking 10% off!!

OK, many thanks guys, I'll give it my best ..

Thanks r937 --- It worked