[RESOLVED] How to add two field in a query

[MichaelHe]

I get my data from at mysql database like this:
SELECT * FROM

In the database I to count fields CountL and CountP.
Now I need to add the two as CountAll and I have tried with :
SELECT (CountL+CountP) as CountAll FROM

But that doesn't seem to work.
So how do I do that ?

And if I get it to work, how do I then get all the other data from the database with having to write them all in the query. I did this with a * but can I use that along with an AS statement. ?

best
Michael
www.festfagbogen.dk

[Installer]

"SELECT (CountL+CountP) as CountAll FROM..." should work. In what way does it not seem to?

Yes, you can use "*" with an "AS" statement.

[MichaelHe]

I have just tried some more, and now it works.
I have to write $countall=$row['CountAll']; after the query for it to work.
I thought it was automaticly put in a variable called countall.

And the I found out.. It was just , (Coun...) As.....

Thanks for your help :o)