I’m writing a plugin for WordPress and I have a table with a AUTO_INCREMENT primary key field called ID. When a new row is inserted into the table, I’d like to get the ID value of the insertion. How do I do this?
I ran into this the other day and tried using is a method called mysql_insert_id which is the standard PHP way of doing this.It didn’t quite work though, as my queries were all going through the WordPress class $wpdb and I couldn’t guarantee that my query was the last thing that was being executed.
Well, it turns out that one can use the class varialbe $wpdb->insert_id which is updated with mysql_insert_id when your INSERT is completed. Now that’s easier than finding a Arai Signet-q when you’re really looking for one right?