On Thu, 7 Feb 2002 22:09:18 -0600, you wrote:
>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].
That did it Paul... Blast I hate it when that happens... <g> I go
blind once in awhile. I try hard to watch for that stuff too. It's
amazing how some things can be so hard to see.
Thanks very much for the help. It'll be flying in no time now.
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
