We need more info.
What is the sql you are using? What is the table structure? How many records have you got in the table?

Is the fact its only echoing 1 result due to the fact that there is only 1 row in the table being queried? Or has the sql got a LIMIT statement in it?

On another note, @ is evil. Every time you use it a small cute fluffy <insert appropriate animal with adequate cute fluffiness here> dies!

For the love god please use braces on control structures, namely the while loop. Same as above applies here.

__________________
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)