Re: [PHP4BETA] re:Totalling a variable in a while loop
| From: | Faisal Nasim | Date: | Tue, 22 Feb 2000 08:33:24 +0000 |
| Subject: | Re: [PHP4BETA] re:Totalling a variable in a while loop | ||
| References: | 1 2 3 4 5 | Groups: | php.version4 |
| Request: | Send a blank email to php-version4+get-10625@lists.php.net to get a copy of this message | ||
<cut>
: $result = mysql_query("SELECT SUM(ItemTotal) FROM Items AS grand_total
WHERE UserID='$Cookie'");
: list($grand_total) = mysql_fetch_row($result);
There is NO need for an alias in this case.
list ( $grand_total ) = mysql_fetch_row (
mysql_query("SELECT SUM(ItemTotal) FROM Items WHERE
UserID='$Cookie'") );
Enjoy!