[miz]

Originally Posted by Dean C

You cannot do a select and update in one query. Drop the COUNT(user.posts) bit and then count the posts as you go along within the while loop. Before the while have $totalposts = 0; then in the while loop have $totalposts += $var['userposts'];

Then you do your update query outside the loop

how ?
cuse every team got other count of posts
and it got replaced in every time the while loop runs

or i got you all worng
can you show me exsample ?