Jay,
It still returns '0'. I think we are missing something. Any other ideas? Anyone
else have any ideas?
Ben
>
> From: "Jay Blanchard" <[EMAIL PROTECTED]>
> Date: 2003/08/04 Mon PM 03:10:15 EDT
> To: "Ben C." <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> 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-----------------
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
