No , well, I found example code for my statistic page :P
But for my comments I have a comment table.. and when someone leaves a comment, the 'read' field has a '1' so i select from comments where read='1' which usually displays either a 0 or however many undread comments there are, and when the user visits their own page, all the 1's in 'read' are wiped to '0'
But for my comments I have a comment table.. and when someone leaves a comment, the 'read' field has a '1' so i select from comments where read='1' which usually displays either a 0 or however many undread comments there are, and when the user visits their own page, all the 1's in 'read' are wiped to '0'

caek
Yeah and thats how it works for both comments and pms.
Try combining that into one query, Im having trouble;http://www.experts-exchange.com/Dat...Q_21365993.html
Try combining that into one query, Im having trouble;http://www.experts-exchange.com/Dat...Q_21365993.html
After all you put me through
You'd think I'd despise you
But in the end I wanna thank you
'Cause you made me that much stronger
You'd think I'd despise you
But in the end I wanna thank you
'Cause you made me that much stronger
Im trying to cut down on queries, I mean 20 for a thread is way too much.
The base rate is 8 (user information, logging visit/host,checking theme, counting pms, counting new posts, logging in online, getting location title).
The base rate is 8 (user information, logging visit/host,checking theme, counting pms, counting new posts, logging in online, getting location title).
After all you put me through
You'd think I'd despise you
But in the end I wanna thank you
'Cause you made me that much stronger
You'd think I'd despise you
But in the end I wanna thank you
'Cause you made me that much stronger
I mean Id like to just use two querys for the comment and pm count, but then again its another +1 to my query count at the bottom which is already too high 

After all you put me through
You'd think I'd despise you
But in the end I wanna thank you
'Cause you made me that much stronger
You'd think I'd despise you
But in the end I wanna thank you
'Cause you made me that much stronger
i'll tell you what i do love.
These 2 threads:
http://forumz.wuggawoo.co.uk/index/thread/1437
and
http://forumz.wuggawoo.co.uk/index/thread/1436
These 2 threads:
http://forumz.wuggawoo.co.uk/index/thread/1437
and
http://forumz.wuggawoo.co.uk/index/thread/1436
btw my fave threads are
http://forumz.wuggawoo.co.uk/index/thread/508
and
http://forumz.wuggawoo.co.uk/index/thread/1364
http://forumz.wuggawoo.co.uk/index/thread/508
and
http://forumz.wuggawoo.co.uk/index/thread/1364
After all you put me through
You'd think I'd despise you
But in the end I wanna thank you
'Cause you made me that much stronger
You'd think I'd despise you
But in the end I wanna thank you
'Cause you made me that much stronger
You can now hide and unhide the top bar if you dont like it.
http://forumz.wuggawoo.co.uk/index/topbar
http://forumz.wuggawoo.co.uk/index/topbar
After all you put me through
You'd think I'd despise you
But in the end I wanna thank you
'Cause you made me that much stronger
You'd think I'd despise you
But in the end I wanna thank you
'Cause you made me that much stronger


