At 22:58 -0500 2/7/02, Floyd Baker wrote:
>On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>
>>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
>>
>
>Well that made sense but unfortunately it didn't work. I see that
>adding strings isn't too good but it's still coming up with array(0).
The other problem is you're access the row element as $row(0).
Should be $row[0].
---------------------------------------------------------------------
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
