At 21:28 -0500 2/7/02, Floyd Baker wrote:
>On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>
>>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>>I have a column of amounts that was getting adding in a loop but I see
>>>there's a sum() function to do this. Should have known. But I can't
>>>make it work. Can someone give me a simple query syntax using php?
>>
>>The SQL SUM() function has nothing to do with PHP.
>>
>>SELECT SUM(some_numeric_column) FROM tbl_name
>>
>>is one example of how it works.
>>
>
>
>That I know. I have your book in my hand... But I'm not able to make
>it work from a php script. By php syntax I mean something like your
>example on page 360 using count(). I'm replacing it with sum().
>
>
>$result = mysql_query( "select SUM('cost') from $table");
>if($row = mysql_fetch_array($result)) print "RESULT = $row(0)";
>
>I get result = array(0)... Can you tell me what's wrong?
Ah.
You're asking SUM() to sum the value of the string 'cost' for each
row of the result set. Assuming that cost is the name of the column
you want to sum, replace SUM('cost') with SUM(cost).
>
>Thanks much.
>
>Floyd
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
