Trouble running $wpdb->query() with last_insert_id

You can get the last inserted ID from $wpdb with the insert_id property:

$wpdb->insert( ... );
$couponId = $wpdb->insert_id

Related Posts:

  1. Using wpdb to connect to a separate database
  2. How to fetch Data in WordPress using MySQLi or $wpdb
  3. wpdb->insert multiple record at once
  4. How to define composite keys with dbDelta()
  5. Inserting Post Meta From SQL
  6. Why does dbDelta() not catch MysqlErrors?
  7. What causes the “max_user_connections” warning on WordPress frontend?
  8. How to execute mulitple statement SQL queries using $wpdb->query?
  9. Database slowdown after update to 3.4.1
  10. wpdb_prepare with multiple or condition
  11. WordPress database error – Error in SQL syntax – I can’t identify any error?
  12. Advanced SELECT query with condtional statements
  13. Redirecting to old domain after migration website
  14. Create table from array with prepare
  15. WordPress running SQL query to update database from form
  16. Have working sql query… trying to adjust it to use $wpdb
  17. Custom WordPress Table wpdb
  18. Best practice to limit results in get_row()?
  19. Query Column of Specific ID from Database Table
  20. How to create more than one new wpdb object?
  21. How to connect and insert data in database of wordpress?
  22. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  23. “BS_” rows in postmeta table
  24. Where is the HTML-handler part in the wpdb class?
  25. WordPress Database Query works in phpMyAdmin but not in the code
  26. insert data from a form:: Warning Empty query mysqli::query()
  27. How can I get $wpdb to show MySQL warnings?
  28. How To connect to the same WordPress database with different database user
  29. using same mysql user with many databases
  30. Uploading to WordPress Database
  31. SQL errors when querying for something with apostrophes
  32. Rename a table in MySQL
  33. How should I tackle –secure-file-priv in MySQL?
  34. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  35. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  36. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  37. MySQL SELECT increment counter
  38. phpMyAdmin – Error > Incorrect format parameter?
  39. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  40. MySQL Database User: Which Privileges are needed?
  41. Why is my database import losing text widget data?
  42. WPDB Insert or if exists Update
  43. How to return number of found rows from SELECT query
  44. get_results using wpdb
  45. Will it break my site if I delete all transient records in wp_options table?
  46. Checking if Database Table exists
  47. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  48. $wpdb won’t insert NULL into table column
  49. Please explain how WordPress works with MySQL character set and collation at a low level
  50. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  51. Get error messages when $wpdb->insert() returns false?
  52. Detecting errors generated by $wpdb->get_results()
  53. Does dbDelta delete columns as well?
  54. wpdb update add current timestamp not working
  55. WordPress Database lost auto increment
  56. Connect to database using wordpress wp-config file
  57. Reset Post IDs to less than 64bit integer
  58. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  59. Restoring WordPress posts from database only
  60. WordPress database scalability from the code perspective
  61. WordPress Unit Testing – Cannot Create Tables
  62. Does wpdb add considerable overhead on queries with large result sets?
  63. Is it possible to define two databases for one installation?
  64. Why does $wpdb return strings for mysql integer values?
  65. Does WordPress use the InnoDB engine for MySQL by default?
  66. $wpdb->prepare() warning in WordPress 3.5
  67. find a random blogid across my multisite network that has at least one post published
  68. Slow wp_term_relationships query
  69. $wpdb->delete column values IN ARRAY()?
  70. How to use “TRUNCATE TABLE” MySQL statement?
  71. Inserting data into custom tables
  72. Hook into $wpdb
  73. Can I use MariaDB instead of MySQL in wordpress?
  74. Display data from a non wordpress database on a page template
  75. How does $wpdb handle COUNT(*)
  76. How might I retrieve a featured post image from an external WP site and display it as a link back?
  77. WordPress database error: [Query was empty] [closed]
  78. Export wordpress table to excel
  79. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  80. How to close wpdb connection? [duplicate]
  81. WordPress for a very large website
  82. What are conventions about the schema of the $table_prefix
  83. Split WP install between 2 databases?
  84. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  85. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  86. Connecting to external oracle database
  87. Is deleting orphaned wp_options entries safe?
  88. Is altering a default WordPress database table update safe?
  89. How to solve slow WordPress site caused by attachment_metadata
  90. Huge wp_options table
  91. “MySQL server has gone away” since update to 3.8
  92. Can’t save ajax value to database
  93. Delete all post meta except featured image
  94. Custom DB_COLLATE (collation) value not working on fresh install?
  95. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  96. what to do when your WordPress database is too large?
  97. Updating all rows of table with $wpdb
  98. Change all http to https in mysql databse?
  99. WooCommerce – Query for ordered products
  100. Large database causes slow load
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)