Database and addition

[thoand]

Hi,

I have this app where people can register request for tickets for a amataur theatre we have :-)

I have one column that store the number of tickets the guest is requesting (tickets int(4))

In my presentation I loop through the list
eg.

{
$tickets += $getPeople->tickets
}

now I have the number of tickets after the loop
eg.

$tickets = 244

I've used this simple teqhnicue in other projects to,
but is this posible using only a SQL query?

thanks for tips and suggestions

best regards
Thomas Andersen

[bastien]

select COUNT(tickets) as total_tickets from table

[thoand]

ok, I found out that I have to use two queries, one for counting totals and one for presenting data.
I was just wondering if there was any functionality in SQL for this so I could do it in one query without using PHP

anyway I found out that you can also use

SELECT SUM(tickets) as totaltickets from mytable;

best regards,
Thomas Andersen