List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 8 2002 4:09am
Subject:Re: How to sum() with php query?
View as plain text  
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 <mysql-thread98914@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-cyon=bestweb.net@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
How to sum() with php query?Floyd Baker12 Feb
  • RE: How to sum() with php query?Intruder12 Feb
Re: How to sum() with php query?Floyd Baker12 Feb
Re: How to sum() with php query?Floyd Baker12 Feb
Re: How to sum() with php query?Floyd Baker12 Feb
Re: How to sum() with php query?Paul DuBois12 Feb
Re: How to sum() with php query?Paul DuBois12 Feb
Re: How to sum() with php query?Paul DuBois12 Feb
Re: How to sum() with php query?Floyd Baker12 Feb