Re: [PHP] Who to make an additon of fetched rows

2001-01-16 Thread K.Simon
yeah, but if the user has 20 items in the cart (=20 rows), how do i show the endprice of his items? In the below example it just prints all the rows from the user but i want to make a simple mathematical addition $DMB+$DMB+$DMB and so on as rows for this user exists. It might simple for you but

Re: [PHP] Who to make an additon of fetched rows

2001-01-16 Thread Chris Lee
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\n"; } Chris Lee Mediawaveonline.com

[PHP] Who to make an additon of fetched rows

2001-01-16 Thread K.Simon
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 ite