php - How can I add to row with highest primary key?

Solution:

MySQL is objecting to your use of theSELECT statement in the where clause on the table you're updating. You should see a response like this:

Error Code: 1093. You can't specify target table 'data' for update in FROM clause

PHP solutions involving thelast_insert_id only work for the lifetime of the session, and then only if no other user is inserting records, so won't be reliable.

Try this:

UPDATE data
  SET Tricked='Affirmative' 
  ORDER BY Identification DESC
  LIMIT 1
Copy code