SQL Statement Error

[Dcalladi]

Hi, i have a SQL statement that is meant to decrease a value of a certain item with using the items same in the where

Iterator itr = items.iterator();
        while (itr.hasNext()) {
            try {
                DriverManager.registerDriver(new com.mysql.jdbc.Driver());
                Connection conn = DriverManager.getConnection("jdbc:mysql://samp.inf.brad.ac.uk/dcalladi", "dcalladi", "Dannys21");
                pstmt = conn.prepareStatement("UPDATE Test_items SET Stock_Level = Stock_Level - 1, WHERE Name = ?");
                pstmt.setString(1, itr.next().toString());
                pstmt.executeUpdate();
                pstmt.close();
                conn.close();
            } catch (Exception ex) {
                System.err.println("SQLException: " + ex.getMessage());
            }
        }
    }

so i have an arraylist called items, i want to pass through that array list with an iterator and with every item i want to subtract 1 from the stock were in the SQL statment name is taken from the arraylist. for some reason i am getting a

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 'WHERE Name = 'Sweet Chilli Sauce'' at line 1

error and dont have a clue why.

and help would be appriciated

[Tolls]

What's that comma doing in the SQL?
You're only SETting one thing...

[Dcalladi]

totally skipped it didn't even realise works now, Thank you very much.

[Tolls]

No problem.
We all get code blindness from time to time.