Count Buddylist
 

I am currently trying to add how many buddies a user has in their profile. And i've tried several ways, and it doesnt get the right number. I tried using count, but that doesnt seem to work. Any ideas?

Look at one of my stats hacks, it has a query showing how.

eh.. it seems that it didnt quite work...

[sql]
SELECT LENGTH(buddylist) - LENGTH(REPLACE(buddylist, " ", "")) AS data FROM user WHERE userid = n;
[/sql]
It works perfectly fine.

Hmm, i added in the code, and i dont get anymore errors, but my result isnt the total number of buddies, its another number.

bump :sleep:

I'm telling you, this works...