This is what I do:
Code:
SELECT R_Rating, R_Rater, U_Username, U_Totalposts, R_What
FROM _forum_Ratings, _forum_Users
WHERE R_Rater = U_Number
AND R_Type = 'u'
AND U_Totalposts < 50
ORDER BY U_Totalposts, R_Rater ASC
I get a list of Users who have less than 50 posts and have done a rating on somebedy.
I also get the name of the user who rated but I don't know how to get the name of the user who WAS rated (R_What is user ID).
Can anyone provide me with solution?
--------------------
Kind regards,
PaNTerSan