Count ? math via query - help

[miz]

i tried to count all users posts and calculte them as team posts

like that

PHP Code:

COUNT(user.posts) AS totalteamposts 


but its count rows and not posts
any idea how i can count all posts via query ?

[Carnage]

try this:

PHP Code:

SELECT sum(user.posts) AS `totalteamposts` 


edit: my error should have used ` not ' (i've done this ever since i had the problem of selecting the coloum `mod` from a table... apparently MOD is an sql function, took me hours to figure out what was wrong there...)

[filburt1]

Don't enclose the table name in quotes.

In ANSI SQL, you should absolutely never use quotes (that I know of) except for literal strings. Column names, numeric values, column aliases, etc. should always be left unquoted.

[miz]

thanx for help
i used

PHP Code:

sum(user.posts) AS teamposts, 


worked like charm