Re: Who to make an additon of fetched rows
| From: | Chris Lee | Date: | Tue, 16 Jan 2001 16:51:15 +0000 |
| Subject: | Re: Who to make an additon of fetched rows | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-34848@lists.php.net to get a copy of this message | ||
well your code snipit allready shows your answer.
$result = mysql_db_query($DBName, "SELECT * FROM basket WHERE
UserID='$UID'");
while ($row = mysql_fetch_array($result))
{
$CID = $row[0];
$DMN = $row[1];
$DMB = $row[2];
$BID = $row[4];
echo "Price: $DMB<br>\n";
}
Chris Lee
Mediawaveonline.com
""K.Simon"" <phpsoft@zabia.net> wrote in message
news:200101161642430703.055992B6@192.168.0.2...
How can i add all the fetched rows from a table?
$result=mysql("$DBName","SELECT * FROM basket WHERE UserID='$UID'");
while ($row = mysql_fetch_array($result)) {
$CID=$row[0];
$DMN=$row[1];
$DMB=$row[2];
$BID=$row[4];
do{
print "$DMB";
}
Let's say i have to display the endprice from all the items from user $UID
in the basket. Price from the items is in row $[2] or $DMB. How can i do
that?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net