I’m a newbie here trying to import some data into my wordpress database (MySQL) and […]
Tag: sql
Optimized SQL query for WordPress users and user meta
What’s a more streamlined way to compose the following query? SELECT wp_users.ID, wp_users.user_login, wp_users.user_email, first_name.meta_value […]
PHP Query comes back as ‘Array’ instead of a name from database
I have the following query: $name = $wpdb->get_results(“SELECT appname FROM `$table_db_name` WHERE ID = ‘$ID’ […]
Retrieve wordpress posts with featured image via SQL
I’m using this query in a PHP script outside WordPress to retrieve entries with their […]
WordPress update other users field won’t work
I need to update 2 users fields at the same time, giving 8 points to […]
Database SQL order by value in column field
I have a WordPress blog with obviously a WordPress database. Database name: wordpress The two […]
Count number of IDs in one column matching multiple defined IDs (rows) in another column
I’m attempting to create a reporting tool that counts the number of posts on a […]
fetch(PDO::FETCH_ASSOC only returning one row
Changing over from what is now depreciated mysql code, over to PDO. This code is […]
meta_query, how to search using both relation OR & AND?
Resolved: See answer below. I have a custom post type called BOOKS. It has several […]
Export entries and multiple custom field meta to .csv?
First time poster. I’m trying to export a bunch of custom posts out to a […]
No More Posts Available.
No more pages to load.