sw0o0sh Posted March 31, 2010 Share Posted March 31, 2010 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. Quote Link to comment https://forums.phpfreaks.com/topic/197086-need-help-using-join-or-at-least-an-idea-on-how-to-approach-this/ Share on other sites More sharing options...
sw0o0sh Posted March 31, 2010 Author Share Posted March 31, 2010 Posted in wrong forum close please Quote Link to comment https://forums.phpfreaks.com/topic/197086-need-help-using-join-or-at-least-an-idea-on-how-to-approach-this/#findComment-1034563 Share on other sites More sharing options...
sspoke Posted March 31, 2010 Share Posted March 31, 2010 looks like runescape classic to me Quote Link to comment https://forums.phpfreaks.com/topic/197086-need-help-using-join-or-at-least-an-idea-on-how-to-approach-this/#findComment-1034641 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.