Shole Posted May 8, 2010 Share Posted May 8, 2010 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 'ORDER BY rand()' at line 1 Query was SELECT i.armor FROM items i WHERE itmid= ORDER BY rand() That i got i replaced the attack.php with ravens script attack.php since i cant find the attack.php of mccodes because my assistant/helper deleted the mcodes and added a new attack.php which doesent work and now he is off line for a week because of school. How can i fix this problem? Quote Link to comment Share on other sites More sharing options...
DigitalGerm Posted May 8, 2010 Share Posted May 8, 2010 Query was SELECT i.armor FROM items i WHERE itmid= ORDER BY rand() don't know how attack.php script looks like, so it's hard to guess. Quote Link to comment Share on other sites More sharing options...
ddgamedesign Posted May 13, 2010 Share Posted May 13, 2010 We'd need to see more of the code to know what was up. Quote Link to comment Share on other sites More sharing options...
Diesl Posted May 18, 2010 Share Posted May 18, 2010 I don't know why you have SELECT i.armor FROM items i.. when you can just do SELECT armor FROM items But if you want to keep it that way, make this change: WHERE i.itmid=......... Quote Link to comment 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.