SQL SELECT statement

[JonnySnip3r]

Hey hope some one can help me with this as i have just recently ran into this problem. Ok here it is i have a comments section on my site and i have made it where users can sort through there comments by a drop down box, so they select the drop down box and its shows categorys then have commented in...

 

php

java

c++ etc

 

now it all appeard to be working when building but now if the user posts say into php twice its shows

 

php

php

java

c++ etc

 

here is the statement i am using

$query = "SELECT * FROM comments WHERE member = '$member'";

would i have to add a LIMIT but im not sure what to do now haha. hope someone can help thanks.

[trq]

$query = "SELECT * FROM comments WHERE member = '$member' GROUP BY category_field";