how to get up row in wordpress with wpdb

you should add another field to your prices table called previous_id and keep it updated on every insert and delete query.

This way you may always have the track for previous record. If you deletethat record, you may assign its previous_id into the next record and if you insert new record, you may add the last available id into its previous_id.

Related Posts:

  1. Is there any plugin development framework
  2. How do I add CSS options to my plugin without using inline styles?
  3. Is wp-content/install.php a Drop-in?
  4. Handling results from data hooked into admin_post
  5. How do I create links at the top of WP_List_table?
  6. How to write testable classes in WordPress
  7. get_template_part from plugin
  8. Edit or Remove Plugin .htaccess Using The Admin Panel
  9. Why Does get_posts() Return an Empty Set?
  10. WordPress scheduled task is called but not executed
  11. How to create collections that are edited in admin?
  12. Get list of available wordpress actions
  13. How can i list current author’s categories?
  14. Use js script from one plugin in another plugin
  15. Rest Api How to get results of child categories with one api call
  16. Build dynamic page from cURL (HTML page) response with plugin
  17. How to store accumulate multiple option values in a single array using Options_API
  18. Add Post and Comments menu no longer visible
  19. template_redirect for single posts w/ custom fields
  20. can I prevent WP users (even admin) from deleting custom categories?
  21. WordPress password reset – why post rp_key?
  22. Proper way to hook wp_get_attachment_url
  23. How to install WordPress Popular Posts plugin twice?
  24. Get the link text
  25. Multisite plugin development and wp_enqueue_script
  26. Is Dreamweaver CS5 a serious choice for theme/plugin development?
  27. How to deal with equal & similar arguments for a function?
  28. What parameter should I pass to wp_enqueue_style to depend on the themes stylesheet?
  29. How do I obtain a list of categories assigned to the current post?
  30. Modify hard-coded conditionals for roles to custom roles
  31. Callback is not called in add_settings_field() when passed as part of an array, but recognises that it’s there. It’s passed Class to Class using OOP
  32. Plugin translations not installed but… strings are translated!
  33. Secure Pages Best Practice
  34. Does wp_login only trigger before an user signs in into the admin panel?
  35. How to access noticeOperations from withNotices
  36. How do I apply a custom discount to individual product total prices depending on their categories on the cart and checkout pages of WooCommerce? [closed]
  37. How to fix this URL error in WordPress ” data-wplink-url-error=”true”>
  38. Remove unwanted elements for a wp_nav_menu
  39. Unit testing a plugin with a theme dependency
  40. Edit Images From the Front End without Access to WP Admin
  41. How to remove or add submenu item on plugin activate or deactive
  42. Update problem with update_option() in combination with register_setting()
  43. Why does my widget break other widgets?
  44. How do I add a text field under the activity texarea? [closed]
  45. Help writing custom function with rewrite endpoint that generates a page from dynamic content
  46. How to make “upgrade safe” theme for a plugin?
  47. Function/Class to list categories with checkboxes
  48. Remove an action by extending class and replacing it
  49. making a plugin that moves other plugins wp_head actions to wp_footer
  50. Is hint for translator compulsory while internationalizing a string containing variables?
  51. Settings API: Setting default option via ‘get_option’ fails
  52. Setting a JSON web token from a secondary api as a secure cookie on WordPress
  53. How to redirect to login page when user not loggedin on a particular page
  54. How to use nonce
  55. WP Still Generating 150×150 Thumbnail Size Even After Un-Setting Small Size in Functions.php
  56. How do I validate extra pin field on my WordPress login form page?
  57. How to create a wordpress widget that dynamically changes according to the page
  58. Non editable custom taxonomy
  59. Does WordPress default CSS have Grids?
  60. Plugin to create Posts and Forums then choose category and parent forum
  61. Checking for existing title in custom db query not working
  62. Adding Permalink to Slides with ‘Simple Nivo Slider’ plugin?
  63. How to add a new taxonomy link to the admin menu
  64. Many Single Sites, One Plugin directory – adjust plugins_url()
  65. insufficient permissions; coding an action for plugin governed by custom capability
  66. My plugin creates custom widgets, How can I programatically add them to existing sidebar widget areas?
  67. Make a php array load faster
  68. Count products with custom metadata field in an order
  69. Include external po file for 3th party plugin to theme
  70. Adding the image selector/uploader to an admin back page
  71. setTimeout not working in jquery
  72. How to know if current plugin is going to be used while rendering the page?
  73. Woocommerce Product finder feature on home page
  74. How do I show the HTML descrption in wordpress photo gallery for my individual gallery pages?
  75. Javascript scroll eventHandler only working when I’m logged in in WordPress
  76. WordPress Reset password Strength set to medium
  77. Add language localisation to javascript alert?
  78. redirect_to how to make it simply work with get parameter or similar?
  79. cancel place order proccess
  80. CPT UI and custom database table
  81. How I can give access to my custom plugin for editor roles user?
  82. Testing Plugins for Multisite
  83. WP: adding Javascript to specific woo commerce pages
  84. Calling dynamic_sidebar in plugin gives error
  85. How to add chunk of php, html, and sql code to variable an append to $content
  86. edit-tags.php in plugin admin menu hides when is the active page
  87. Best way to handle a form post in plugin
  88. Why does this fail: Disabling plugins enqueue_script() in functions.php
  89. How To Remove The Filter That Adds JetPack Related Content To Dom [closed]
  90. Fixing plugin for wpdb::prepare
  91. Remove text from confirmation message
  92. Can I use an array to create multiple tables?
  93. How to display .ptm file in my WP site without JAVA
  94. How to replace content of a block in and re-render on change?
  95. extending a core block doesn’t work inside the editor
  96. register_activation_hook doesn’t execute without add_action(‘init’,’some-function’)
  97. Getting similar posts by custom field value
  98. Does WP REST API cache internally executed (rest_do_request) requests?
  99. Trouble Importing whatsapp-web.js in a WordPress Plugin Development
  100. ‘useSate’ error when using React on the frontend in custom block plugin