adding up total of fields

[jonathen]

Hi all,

I am trying to (I think this is possible) add together the numeric values of one field in all rows, and gain the total amount.

I have used:

$query = "SELECT SUM(seats) as how_many,seats FROM $sqlbookings GROUP BY seats";
$list_seats = mysql_query($query) or die(mysql_error());
mysql_close();
while ($row = mysql_fetch_assoc($list_seats)) {
echo $row['how_many'];
}

For example, let's assume I have 3 rows, 1 has the value of 100, 1 has the value of 50, and 1 has the value of 5. The total should be 155. However, the above echoes out: 100505 - it is putting together the amounts, as opposed to adding them up.

Is there a way I can work around this?

[Frederick]

$sql = mysql_query("SELECT sum(seats) FROM $sqlbookings")
or die(mysql_error());

$count = mysql_result($sql,0,0);

echo "$count seats have been reseved.";

[jonathen]

Ahh, that's what I was trying to achieve - what a long-winded way I took trying to get there, lol. Thanks for that - now I can finally add up how many players (online gaming) have booked places for games.

Ta very much 🙂