Wpdb->insert() doesn’t insert new row after the last one

This really has almost nothing to do with WordPress.

You probably haven’t created a primary key for your shops table, which should probably be shopid (assuming you’re using normal column naming conventions)

Related Posts:

  1. How to return number of found rows from SELECT query
  2. Can i use php sql functions instead of $wpdb?
  3. wpdb::prepare was called incorrectly
  4. Custom query to get post names beginning with a digit
  5. queries inside of a class
  6. PHP syntax error when using wpdb update?
  7. “The plugin generated 2694 characters of unexpected output…” on Plugin activation, CREATE TABLE sql command not working
  8. Ajax $wpdb not returning table data
  9. Converting MYSQL to WordPress $WPDB
  10. How to Fetch values from WP database based on selected option value by onchange using PHP?
  11. Call External Object in Class Function During Callback
  12. Why is variable not working on custom sql query using wpdb?
  13. Get stock by custom meta field on all Woocommerce variable products
  14. Any possible way to make $wpdb->get_results() return anything else than array?
  15. Display fields as values in array from external SQL DB
  16. Can’t get wp_insert_post to work
  17. Trying to establish connection to External Database
  18. Getting id of poll from WP database
  19. How to insert a single row to WP database table?
  20. WSoD being caused by this piece of code
  21. I want to select the from values from database in WordPress? [closed]
  22. $wpdb->update with multiple parameters gives error
  23. Update results, Before deleting the related category [closed]
  24. How WordPress reacts to a lack of memory of the server [closed]
  25. wpdb php get_var query to get ID for URL image doesn’t work for ID over 999
  26. wp query foreach deleting record returning only first or last item
  27. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  28. $wpdb->insert() does not Insert record in a table
  29. Custom array from a query only write the last row of the query
  30. Error using WordPress $wpdb object to get result from custom table
  31. How to retrieve the data from the sever and displaying it in a page?
  32. Querying Database with wpdb
  33. Can’t update multiple rows with $wpdb query
  34. Mixing variables into an array when inserting values
  35. how to get serialized post meta
  36. Use $wpdb or other PHP script method to find/replace in WP database
  37. How to get specific attribute from DB
  38. Basic wpdb update question
  39. wpdb Cannot Update column in Database
  40. How to use mysql LIKE with wpdb?
  41. PHP -> SQL Query with Summing
  42. How to insert wp_users ->user login name to wp_terms when a new user registering?
  43. Cannot access $wpdb, comes back NULL
  44. How do I prepare strings for insertions as values into a MySQL table?
  45. Change MySQL PDO connection to a WPDB connection
  46. WPDB – Read and write value from / to database
  47. $wpdb->get_results breaking page?
  48. form $_post action value gets truncated after it passes through two forms
  49. How to Generate a list of Most Commented post?
  50. Why won’t this wpdb get_results query return results?
  51. WPDB secure custom form
  52. Undefined variable: row?
  53. Add row to custom database Table and delete all rows older than 1 day
  54. Call to a member function get_row() on a non-object, Unable to use global $wbdp inside a plugin
  55. select a single val though a table in wordpress
  56. populate select options from extra mysql table data
  57. Query the links Database
  58. WordPress get last inserted user id
  59. Add posts to custom table in database instead of wp_posts
  60. Isn’t Returning Value While Using SELECT COUNT(*) FROM {$wpdb->prefix}
  61. WordPress SQL Prepare
  62. Creating multiple tables with Plugin
  63. Conditional formatting on data fetched from MYSQL
  64. What is the correct way to search 3 custom fields only in WordPress?
  65. Using wpdb to connect to a different database is not working
  66. Looping through custom data in a custom table to display all items in a post
  67. Displaying SQL query result from user input via wpdb
  68. How do I create a WP endpoint that retrieves all custom post types that have a tag?
  69. 403 Forbidden WordPress Database Results
  70. How to grab data from input and store it into custom table in database?
  71. Rewrite SQL query as a prepared statement and use in foreach loop
  72. How to return count of items found in SQL query
  73. Update user_email via php – WP 4.7
  74. Unable to pass variable to database
  75. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  76. Passed variable gets undefined variable error on insert on next page
  77. Run insert if no entry otherwise run update with ajax
  78. MySQL queries in WordPress
  79. At what point during a typical request does the $wpdb object become available?
  80. Get null from POST
  81. Querying multiple meta_keys in WordPress SQL query
  82. MySQL database migration to WordPress
  83. Fetching wpdb data from a php file seems to break?
  84. How do you get a reference to $wpdb in a PHP script
  85. Insert into db with foreach problem
  86. posts_clauses drop ACF get_field function
  87. How to display inputted data in Ajax without button or click event
  88. WordPress Query -> Ajax Query
  89. how to display tables via ajax
  90. Changing regular db connection to $wpdb
  91. Can’t send form data to wpdb when URL has query string
  92. use wpdb object on other file
  93. $wpdb how to make a record lookup
  94. How to get data (not value or name) from radio options to POST to database
  95. Error resetting database index using ALTER TABLE in $wpdb->query
  96. Warning: Undefined property: wpdb::$question_overview in C:\Wamp.NET\sites\proxyvragenmodule\wordpress\wp-includes\class-wpdb.php
  97. WordPress / PHP: Check if column has value and then check if value in array
  98. Putting form result in my database
  99. SQL – How to echo out inside of where statement
  100. How can I update a value of a field depending on outside source?