Need help using JOIN, or at least an idea on how to approach this.

[sw0o0sh]

Hi, I am coding a highscores for a game website. Currently, I am working on an "opt out" and "opt in" feature for the highscores. If the user is opted out, their rank does not display, if they are opted in, their rank does.

 

Anyways, the rank experience is stored in a table called "rscd_experience". When the highscores table shows results, it loops through this. When they set whether they want to OPT in or out, it is stored in rscd_players.highscoreopt (as either 0 or 1 value).

 

How would I make this query:

 

$grabSkill = $db->query("SELECT DISTINCT(user),exp_" . $getSkill . " FROM rscd_experience ORDER BY exp_" . $getSkill . " DESC LIMIT " . $db->escape($fixStart) . " , 20");

 

Detect for rscd_players.highscoreopt ? (And if 1, do not display)?

 

I think I'm going to need some clear cut examples to understand this clause, it seems rather complicated. I don't even know if JOIN is meant for this. Thank you in advance for any help.

[sw0o0sh]

Posted in wrong forum close please

[sspoke]

looks like runescape classic to me