[SOLVED] Need help with sub query:

[ted_chou12]

SELECT * FROM forum WHERE threadid=(SELECT threadid FROM forum WHERE username='{$r6['username']}' AND threadattribute!='votethread' GROUP BY threadid) AND threadattribute='topthread'

but it doesn't seem to appear anything, is the subquery used correctly?

Thanks,

[fenway]

Really? Did you even look at mysql_error() after executing the query? You can't just throw group by wherever you want.