Count Buddylist

[joeboo]

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?

[filburt1]

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

[joeboo]

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

[filburt1]

SELECT LENGTH(buddylist) - LENGTH(REPLACE(buddylist, " ", "")) AS data FROM user WHERE userid = n;

It works perfectly fine.

[joeboo]

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

[joeboo]

bump :sleep:

[filburt1]

I'm telling you, this works...