RE: Re: [PHP] Addin a column of numbers not using MySQL
| From: | Ben C . | Date: | Mon, 04 Aug 2003 20:01:19 +0000 |
| Subject: | RE: Re: [PHP] Addin a column of numbers not using MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-158212@lists.php.net to get a copy of this message | ||
Jay,
It still returns '0'. I think we are missing something. Any other ideas? Anyone else
have any ideas?
Ben
>
> From: "Jay Blanchard" <jay.blanchard@niicommunications.com>
> Date: 2003/08/04 Mon PM 03:10:15 EDT
> To: "Ben C." <benc@cox.net>, <php-general@lists.php.net>
> Subject: RE: Re: [PHP] Addin a column of numbers not using MySQL
>
> [snip]
> ----CODE Begin-----------------
> $sql_2 = "SELECT SUM(paidamount) as paid
> FROM $tb_name
> WHERE id = \"$id\"
> ";
>
> $result_2 = @mysql_query($sql_2,$connection) or die(mysql_error());
>
> while ($row = mysql_fetch_array($result_2)) {
> $paid = $row['paid'];
> }
> ----CODE End-----------------
> [/snip]
>
> FOUND IT!
>
> ----CODE Begin-----------------
> $sql_2 = "SELECT paidamount
> FROM $tb_name
> WHERE id = \"$id\"
> ";
>
> $result_2 = @mysql_query($sql_2,$connection) or die(mysql_error());
>
> while ($row = mysql_fetch_array($result_2)) {
> $paid = $row['paidamount'];
> $total = $total + $paid;
> }
> ----CODE End-----------------
>
>