simple, i think.

[anthill]

Hi,

I've been working on this for too long now I have a memory block 🙁 Anyway, i'm pulling some values from a database in a for statememt.

20
20
60

is how they are being display in the table.

how do I add them together to get
20
20
60
100

Thanks

Ant

[cgraz]

can you post some of your code?

Cgraz

[anthill]

ok, it reads from a cookie and then connects to a database and displays the results:

foreach ($_COOKIE['basket'] as $name => $value) 
     {

 $read = split(" ", ($value));

 $item = $read[0];
 $quantity = $read[1];

 $db = mysql_connect("localhost","username","password");
 mysql_select_db("database",$db);

 $query = mysql_query("SELECT * FROM products WHERE model='$item'");
 $get = mysql_fetch_array($query); 

echo "<table><tr><td>".$get['price']."</td</tr></table>"

}

so that will give me the values, in each table. All i wanna do is add the prices together to get a total.

Cheers

[mahers]

$total += $get['price'];

Then echo it outside of the loop. Also you only need to connect to the database once so placing the mysql_connect() function inside the loop isn't helping. Same goes for selecting the db.

[anthill]

cheers!! i knew it was something simple 🙂

thanks!!!

Ant