Join question I think??

[Dean C]

This is not a nice way of doing it - firstly if this is for vB make use of the built in class.

mysql_query(); = $DB_site->query();
mysql_fetch_array(); = $DB_site->fetch_array();

And so on...

Secondly use templates as it's a lot cleaner method

Thirdly for your join

PHP Code:

SELECT reputation.*,user.* FROM reputation LEFT JOIN user ON user.userid=reputation.userid ORDER BY $order 


-------

You may want to try and limit it too as if you have 100+ users as soon as they all have their reputations you're going to be pulling 100+ users at a time.