Technically, you should use WP’s built-in class WP_Query to pull the information and I am sure that will alone simplify your entire process.
Related Posts:
- WordPress Paginate $wpdb->get_results
- Can I use $wpdb for my custom tables in the WordPress database?
- What’s the proper way to use a custom table? [closed]
- Why would switch_to_blog stop working?
- $wpdb->replace: WHERE?
- $wpdb->insert running multiple times?
- wpdb custom tables without plugin
- Custom select query two tables by a meta key
- What is my error trying to create a new table in the database?
- How to have differents sites share the same tables of DB?
- Custom WordPress SQL Query 4 posts per custom taxonomy
- How to: Easily Move a WordPress Install from Development to Production?
- Is there a flowchart for WordPress loading sequence?
- Essential technical features for high-end WordPress web hosting? [closed]
- How to remove admin menu pages inserted by plugins?
- How to put logs in WordPress
- How to get the Date Format and Time Format settings for use in my template?
- Where are Additional CSS files stored
- Best Practices for Regression Testing WordPress Websites?
- Remove wrapping div and ul from output of wp_nav_menu
- What Is The Use Of map_meta_cap Filter?
- get post author id outside loop
- Custom Walker: how to get ID in function start_lvl
- Creative uses of WordPress [closed]
- How to *remove* a parent theme page template from a child theme?
- How do I make my child theme re-apply the settings that were customised when its parent was active?
- Multiple Inputs in a Customizer Control
- New WP_Customize API – how does it work under the hood?
- Embedding a SOAP Client into a WordPress Plugin?
- Is there anything that Joomla or Drupal can do that can’t be done in WordPress? [closed]
- Update widget form after drag-and-drop (WP save bug)
- Data sanitization: Best Practices with code examples
- How to benchmark a WordPress installation? [closed]
- Should I delete the default themes?
- Moving WP install from local to live, what about wp_posts GUID?
- Modified wp.media.view.Settings.Gallery in Backbone JS, but editing doesn’t work
- Running Gutenberg React in Development Mode
- Prevent WordPress from automatically installing a new theme each year
- Can we use one WordPress installation for multiple databases, domains and content directories
- Is there a blank theme framework compatible with WP 3.0? [closed]
- Plugin SVN & update API – how are plugins identified?
- Users with custom roles not showing in post author select box
- How to use more than 256MB of memory in the admin?
- How do register_sidebar() and get_sidebar() work together?
- How do you get formatted content of a post using the WordPress API?
- Localization: I want the backend: english and frontend in defined language
- How to delete all records from or empty a custom database table?
- Are there any forks of WordPress (and what is different about them)?
- How to Change 404 page title
- Make Custom Metaboxes Collapse by Default
- Custom maintenance page
- Add button to TinyMCE bar without creating a plugin
- Why do I get the timeout warning?
- How to add a new product type on woocommerce product types? [closed]
- How to include own css on wordpress tinymce editor?
- How to disable page delete
- add button to post edit page when post_status=publish
- how to override woocommerce specific loop or archive-product.php [closed]
- Modify existing plugin function using filter (without modifying the plugin directly)
- Rename UPLOADS folder with custom WP_CONTENT_DIR
- WordPress hook before inserting post into database
- Any post install tips after installing WordPress 3.0.1?
- Making Custom Fields Standard in the Admin UI
- Remove WordPress theme from a specific page
- Version Control: Entire site or just pieces?
- Getting a stack trace when an error occurs?
- Check for and enforce unique value in user-entered custom meta field in WP Admin
- Backup the Database and Restore from the Backup?
- get_pages() not ordering as it should
- Scaling a WP eCommerce site
- Custom Search Query
- How to remove comment section from page only , not from posts pages?
- Looking for a lightweight theme using WP3 new tags and features (not 2010) [closed]
- Why doesn’t WP_Image_Editor save images using the Filesystem API?
- Pitfalls when Distributing Plugins that Access SOAP Web Services?
- How to get current_cat in navbar, in single post
- Default value for add_settings_field
- Seamless integration between WordPress and BBpress
- WordPress 3 MU for a development/stage/production site
- Disable Visible Edit Shortcuts in the Customizer
- How to make a script load after Custom Block is loaded in the editor?
- Updating WordPress overwriting customization tweaks – strategies?
- What is the best way to customise admin files so they survive future upgrades?
- Hide admin notices/notifications from everyone but super admin?
- Change the login button on the login page
- How to customize the default HTML for WordPress Attachments
- Verify nonce in REST API?
- Add custom html to last sub-menu item
- Get all products with a custom attribute
- Why does $wpdb return strings for mysql integer values?
- Customizing the Subject Field in WordPress’ Notification Emails?
- How to update the delete user confirmation form?
- How to move wp-content (or uploads) outside of the WordPress directory
- Need help with friendly URL’s in WordPress
- How to add Disqus comment count
- How to keep a WordPress site synchronized between two servers?
- Upgrading WordPress and Plugins; any Tips to Avoid Trouble?
- Modify column_author in WP_Comments_List_Table
- Why do folders have Empty Index.php Pages?
- How to Add Customizer Setting in Child Theme