Hi All,

I'm looking to try and work out how many times a userid appears in a database so i can work out who has the most Hugs in my bebo application.

Is there anyway to be able to do this?

Any help would be greatly appreciated.

Regards,
Martin

SELECT COUNT(column) as aliasname FROM table WHERE useridcolumn = userid;

Originally Posted by chrishirst

SELECT COUNT(column) as aliasname FROM table WHERE useridcolumn = userid;

This is good, but i need to be able to dynamically check everyones id's against it then check which one is the most.

Also what do you mean by aliasname? (Username?)

Regards,
Martin

SELECT MAX(COUNT(column)) AS alias FROM table

alias sets a name so you can refer to it in the result recordset ( $result['alias'] )

Originally Posted by chrishirst

SELECT MAX(COUNT(column)) AS alias FROM table

alias sets a name so you can refer to it in the result recordset ( $result['alias'] )

Thanks for your help, but i've decided its easier to just set a counter in the users table which will count them up everytime a hug is sent to the user etc.. and that way its just a simple sql query to get the one with the most.

Thanks Anyway your help is much appreciated.

Regards,
Martin