I have the following code
and always get->

Have you run the query against the database to make sure it is correct? Echo that query out and copy & paste it into phpmyadmin or something like that. You might refer to a non-existent field into your query (mistype?).

__________________

Your SQL query has errors where you write the table names. Anything in back-ticks (`) is taken literally so the query is read as though you're looking for tables literally named dom.user_comments and dom.members within the current database (assuming, dom). If you really must use back-ticks then a corrected query would be:
SELECT * FROM `dom`.`user_comments`, `dom`.`members` WHERE ...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

__________________
You're Everyday Graphic Artist
Twitter|GigPark|Linked In

grrrrrrrrrrrr

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

It means that whatever mysql_query returned was not a result resource, therefore it must have failed somewhere.
try:
that wil give you a better idea what the problem might be

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

got it working, :D.

__________________
You're Everyday Graphic Artist
Twitter|GigPark|Linked In