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?
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
