I'm getting an error in java and mysql connectivity..its related to date comparing in java and mysql
`String x=jTextField1.getText();`

After connecting to the database the query is:

`String query="INSERT INTO student(A) VALUES('"+a+"') where date=' " +x+ " ';";

stmt.executeUpdate(query);`

*a is a string which has a letter P assigned to it.

**The error** i am getting is "....check your mysql syntax....corresponding to the date='"+x'"; "

I want to compare the date entered in the textfield to the date in the mysql 'date' column and if it is correct,the 'a' value (which is P) should be written in column A in the same row of the date entered...

Please help...

Thank you...
I'm getting an error in java and mysql connectivity..its related to date comparing in java and mysql
===

`String x=jTextField1.getText();`

After connecting to the database the query is:

`String query="INSERT INTO student(A) VALUES('"+a+"') where date=' " +x+ " ';";

stmt.executeUpdate(query);`

*a is a string which has a letter P assigned to it.

**The error** i am getting is "....check your mysql syntax....corresponding to the date='"+x'"; "

I want to compare the date entered in the textfield to the date in the mysql 'date' column and if it is correct,the 'a' value (which is P) should be written in column A in the same row of the date entered...

Please help...

Thank you...