Help With a Syntax Error

[Urbanhack]

Hello Guys.. Some One Can Help Me With This Error:

Here Is The Error In Console:

 

 

And This Is The Java Code:

PreparedStatement statement = con.prepareStatement("" + "SELECT" + "characters.charId," + "characters.char_name" + "FROM" + "characters.account_name = accounts.login" +"WHERE" + "characters.onlinetime > 0" + "GROUP BY" + "accounts.lastIP" + "ORDER BY" + "characters.level" + "DESC");

 

Thx A Lot!

[B1ggBoss]

use

PreparedStatement statement = con.prepareStatement("SELECT charId, char_name FROM characters WHERE account_name = ?");
statement.setString(1, "The_Account_name_goes_here");

 

Your error is caused because you dont let spaces anywhere, and the mysql engine cannot distinct between commands, columns and parameters

 

[Urbanhack]

Then.. This Is Right?:

 

PreparedStatement statement = con.prepareStatement("" + "SELECT" + " characters.charId," + " characters.char_name" + " FROM" + " characters.account_name = accounts.login" +" WHERE" + " characters.onlinetime > 0" + " GROUP BY" + " accounts.lastIP" + " ORDER BY" + " characters.level" + " DESC");

[B1ggBoss]

i still dont understand why you use "string" + "string" + etc...

Also, you dont need to specify the table name before the column to call

[Urbanhack]

because this code isn't mine... anyway i solved from myself..

thx you a lot!

close this th pls.

 

GL ;)