Jump to content
MakeWebGames

home mod


keez123

Recommended Posts

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'r+IQ > 500 AND us.userid != 1 AND u.user_level != 0' at line 1

Query was SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.strength+agility+guard+labou r+IQ > 500 AND us.userid != 1 AND u.user_level != 0

do you know what my problem is?

Link to comment
Share on other sites

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'r+IQ > 500 AND us.userid != 1 AND u.user_level != 0' at line 1

Query was SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.strength+agility+guard+labou r+IQ > 500 AND us.userid != 1 AND u.user_level != 0

do you know what my problem is?

This should work

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

Link to comment
Share on other sites

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'r+IQ > 500 AND us.userid != 1 AND u.user_level != 0' at line 1

Query was SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.strength+agility+guard+labou r+IQ > 500 AND us.userid != 1 AND u.user_level != 0

do you know what my problem is?

Check your get_rank function under global_func.php.

Remove the space from between the u and the r in labour ... as well as in line 19 in the code from post #11.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...