i want to write a select query but i get error
(the error is mentione the and section in select query)
String select = "Select *"+" from tseller where name=? and manfac=?"; pstmt = con.prepareStatement(select);
ResultSet rows = pstmt.executeQuery(select);
do you know what is wrong?
SQLException: 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 '? and manfac=?' at line 1
do you have any idea whats wrong?