List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 8 2002 3:07am
Subject:Re: How to sum() with php query?
View as plain text  
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 <mysql-thread98909@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