RE: Re: [PHP] Addin a column of numbers not using MySQL
| From: | Ben C . | Date: | Mon, 04 Aug 2003 21:10:24 +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-158214@lists.php.net to get a copy of this message | ||
Jay, No results are returned. It is blank.
>
> From: "Jay Blanchard" <jay.blanchard@niicommunications.com>
> Date: 2003/08/04 Mon PM 04:57:17 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]
> Unsure. How would I do that?
> [/snip]
>
> Ben I think that we have a communications failure. Let's start
> over...you wish to total a database column using php, correct?
> Everything that you have been shown so far will do that. Is it possible
> that there are no query results? If not, then we are doing the query
> wrong. Try it with single quotes;
>
> $sql_2 = "SELECT paidamount FROM $tb_name WHERE id = '" . $id . "'
> ";
>
> Please do a verbose check on the query to see if it is working properly
>
> if(!($result_2 = mysql_query($sql_2, $connection))){
> print("MySQL reports: " . mysql_error() . "\n");
> exit();
> }
>
> Let's use objects instead of arrays (humor me for a moment)
>
> while($row = mysql_fetch_object($result_2)){
> $paid = $row->paidamount;
> echo "$paid \n";
> $total = $total + paid;
> }
>
> echo "$total \n";
>
> Please copy and paste the results into your reply
>