What are you expecting back from the sql statement?
And what are you getting?
From what I can tell, if you are getting all your amounts from the select
statement then you are already totalling them up inside the select
statements by using the sum() function call.
if you are wanting, or
On Tuesday 05 August 2003 23:22, Jim Lucas wrote:
also, I just noticed that you are using double quotes in your statement. I
have always had bad luck with using double quotes. I would switch to
single quotes.
His sql statement assignment looks fine to me. Whether you mainly use
Mike Fifield wrote:
I am using the mysql sum() function to return the sum of a bunch of dolor
amounts stored float values. But what I get back it something like this
98.18855591 it is to precise. All I want is the dolor amounts added up
and rounded up to the closest penny. Is there a
3 matches
Mail list logo