1 more left join problem :(

[miz]

Originally Posted by sabret00the

you're best bet would be to psuedo cache the data

in the while have

$count++
$row[$count] = $totalteamposts

then outside of the while add up the data from $row[0] -> $row[10] and beneath that to the update

saying that, not being sure if you can do that, it might now work.

actually ignore that, i know it's simpler than that, i'll have to come back to this, my minds gone blank

heh
well dosent help me much
my problem isnt about counting cuse im doing it on the first query
my problem is to update
do i need to run exstra query for every team ?
there must be an other way... to update all teams in 1 query.