sspoke Posted September 6, 2007 Share Posted September 6, 2007 This is my error... [java] java.sql.SQLException: You have an error in your SQL syntax; check t he manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `id` = 1' at line 1 this code I use. delbank = con.prepareStatement("DELETE FORM `user_bank` WHERE `id` = ?"); delbank.setInt(1, databasePlayerID); delbank.executeUpdate(); what is wrong with Query nothing.. I see.. I get no good help at MySQL section either. setInt(1, databasePlayerID); replaces the ? with 1. Quote Link to comment Share on other sites More sharing options...
teng84 Posted September 6, 2007 Share Posted September 6, 2007 what is this "DELETE FORM `user_bank` WHERE `id` = ?"<---? and can explain it clearly ? Quote Link to comment Share on other sites More sharing options...
Jessica Posted September 6, 2007 Share Posted September 6, 2007 Just put 1 instead of ?. Your method is superfluous. Also, it's FROM, not FORM. Quote Link to comment Share on other sites More sharing options...
sspoke Posted September 6, 2007 Author Share Posted September 6, 2007 OMG I SPELT FROM WRONG ROFL!!!!!!!!!!!!!! NOW IT WORKS Hahahaha. Thanks 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.