plugin code is pulling information from database in one instance and not in other. What is wrong?

In general, I’d recommend to read about $wpdb in detail in the Codex.

Some notes:

  1. Never use the default wp_ prefix.
  2. Never set a hard coded prefix. It will be set during installation and should later be added using $wpdb->prefix. But: Prefixes can be changed with the following SQL command.
    "RENAME table wp_posts TO {$wpdb->prefix}posts;"
  3. Normally there’s always a way to get around custom tables. CPTs and Custom Taxonomies are just an example.

Related Posts:

  1. How to delete all records from or empty a custom database table?
  2. Is their any way to Extend WPDB class and Overwrite the Default Query Function
  3. Doubt using $wpbd->get_col for a single column
  4. Access WordPress database outside of WordPress
  5. Help With MySQL to WPDB Query Conversion
  6. Create a table with wordpress plugin boilerplate
  7. WordPress and a secondary database?
  8. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  9. WPDB: Update table
  10. Issue running db create table query from static method
  11. Always get creating a new table with foreign key
  12. How to access the WordPress DB from a plugin file
  13. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  14. $wpdb->delete not working for me
  15. How to securely controlling data without keeping it in postmeta?
  16. Write mysql credentials in plugin
  17. Proper way to trigger a MySQL query via link in a plugin
  18. get_var result empty for query of custom table in plugin admin
  19. Is it safe to increase/alter the size of the wp_post.guid column from VARCHAR(255) to VARCHAR(2048)?
  20. Delete tables from database when deleting plugin
  21. WordPress sharding: which multi-DB plugin to use?
  22. Simple form that saves to database
  23. Using Vagrant for customizable WordPress Multi-sites [closed]
  24. How do I check what plugins are enabled via the database?
  25. Stackoverflow type of badge plugin giving warnings in WordPress 3.5
  26. How to update widget_text in the wp_options table
  27. prefix table and plugins
  28. how to show database content in wordpress post
  29. What is the easiest way to implement cascading database upgrade for my plugin?
  30. [Plugin: Posts 2 Posts] How does it work?
  31. Storing Email Account Passwords for SMTP Mailing for a WordPress Plugin
  32. Remove obsolete plugins artifacts from database tables
  33. If I delete plugins via FTP are settings kept in DB?
  34. What kind of data is that?
  35. Cannot login to ADMIN even after changing password in phpmyadmin
  36. Embed a Google Sheet as you view it in a separate tab?
  37. Where does WordPress store plugin (enabled/disabled) status for multisite?
  38. Plugin echos text from shortcode function in gutenberg page editor
  39. How to access data in wordpress database externally using php
  40. custom user tables supported in SharDB plugin?
  41. Creating mySQL procedure with $wpdb
  42. How to check if tables in WordPress still exists after activations
  43. Prevent duplicate records in plugin table
  44. Automatic switch to backup database on fail
  45. WordPress Integration with Google Groups
  46. WP Query. Is there a maximum size?
  47. wp_editor content in plugin options page
  48. Why this function not working for install database on plugin activation
  49. How Can I Put Meta_Compare in the Database-Query?
  50. Can I create a table on my DB without creating a plugin?
  51. WordPress : Explain Plugins & Theme string value in database
  52. Plugins in WP_Options but not Active
  53. How to insert multiple postmeta values with one query?
  54. Gathering and logging data from a plugin: how to do it without race conditions?
  55. How to pass the API key to the client from the database? [closed]
  56. dbDelta not adding additional columns in plugin database update
  57. Updating options into the wp database performance
  58. Taxonomy Drill-Down / Plugin Help – hierarchical queries within plugin?
  59. Best practice to limit results in get_row()?
  60. Ajax save data to database on document ready, no data being saved
  61. Plugin has added weird data in wp_options, set to autoload
  62. External wpdb connections in different plugins on single page
  63. Mowing site to another domain in simplest way
  64. WordPress plugin: efficient way to store large data
  65. Is this plugin safe to run?
  66. Integrating Custom Database with WordPress
  67. Getting URL GET parameter with Code snippets and storing it in database?
  68. Same Plugin tables between wordpress installations
  69. How to fetch WordPress database values in JavaScript widget
  70. create pages automatically and dynamically in wordPress
  71. How to insert a value to decimal type field using wpdb->prepare?
  72. How to get inserted row IDs for bulk/batch insert with wpdb query?
  73. add_action(‘the_content’, ‘my_plugin_content’) is null
  74. Using id to show item
  75. WordPress database problem wp_posts, primary key
  76. How to allow URL with filename & extension in wordpress?
  77. Programmatically generate new pages for a site based on page template and content elements accessed via DB
  78. Remove special characters from filenames
  79. PHP message: WordPress database error Deadlock found when trying to get lock
  80. using wordpress login details for other website / application / forum?
  81. how to create database to use it in wordpress website?
  82. how can i get records from wp_postmeta table using particular meta_key in database?
  83. How to create a custom page for unrelated database?
  84. User content database [closed]
  85. Having trouble going from Jfiddle to implementing in WordPress :(
  86. wpdb get_results() returns only 2 rows
  87. Collaborate on wordpress local website, share files via dropbox?
  88. How to find an option in the database?
  89. Is there a plugin that will override the “Error establishing a database connection” message? [closed]
  90. Get the url of attachments from the post?
  91. Create New Admin Menu Section – Like how custom post type works, in a way
  92. Using wp config to connect to a DB from a plugin
  93. Shortcode returning specific content of a post
  94. How to dispaly post informations (such as titles) in an admin plugin menu page?
  95. get_option returning a different value from what’s saved
  96. How can I delete the options from DB when the plugin is deleted?
  97. register_activation_hook not working
  98. Very slow page loads
  99. Form with response button after on table after submission
  100. Can’t save formdata in DB
techhipbettruvabetnorabahisbahis forumutaraftarium24edueduseduedusedueduedueduseduedus