The wpdb class, accessed via the $wpdb global variable, is used to interact with the WordPress database

learn more… | top users | synonyms

0
votes
1answer
547 views

$wpdb->get_col and ORDER BY?

this is the query that returns the listing of a custom post type $apartments = $wpdb->get_col( " SELECT DISTINCT( post_id ) FROM $wpdb->postmeta ...
1
vote
1answer
2k views

using $wpdb to get custom post type with term

I'm trying to get the title of the first custom post type with a specific term in a taxonomy. But I'm not great at SQL so therefor not great with using $wpdb. Here is my code: $posts = ...
0
votes
2answers
1k views

Inserting into data into external DB using WPDB

I'm trying to work with an external db in Wordpress for the first time and can't seem to get it to insert the data into the DB. Here's what I have: <?php global $wpdb; $url = ...
0
votes
1answer
81 views

Adapting plugin for custom post type?

I am trying to reformulate a function (in a plugin) so that it applies to posts in a custom post type rather than normal posts. function saving_posts($post_id) { global $wpdb, $user_ID; ...
0
votes
2answers
3k views

Getting value from database table depending on field value

I am using a plugin called formidable which is similar to Gravity Forms in terms of purpose. I have two fields of interest. The first field loads up all the values in the Town column of my ...
-1
votes
2answers
2k views

Can't pass variable in wordpress wpdb->get_results

I wanna pass a variable, but always get the error message Invalid argument supplied for foreach()... Here is my code: function second($taxonomies) { global $wpdb; $result = ...
1
vote
0answers
54 views

Sorting main query by custom taxonomy slug

Is there a way to sort posts by custom taxonomy (shoe_color) ASC|DESC? I would like to do this using query_posts and passing the orderby=shoe_color into it. Here is the code I'm trying to work out: ...
-1
votes
1answer
75 views

How to get one result using wpdb class?

function asec_get_link_color() { global $wpdp; $query = "SELECT value FROM wp_theme_options WHERE property = 'link-color'"; $result = $wpdb->get_results($sql); return $result; } ...
0
votes
1answer
150 views

Custom Query for searching through custom fields

Just wondered if someone could spare 5 mins to help me understand where I might be going wrong. I have a set of custom fields for jobs - I would like to create two drop down menus as a quick search: ...
0
votes
1answer
139 views

wp_Query with 4 post meta feald arguments gives 500 internal server error

I am creating a custom plugin to search for custom post type provided with 4 meta field arguments. I am using wp_Query() to fetch the search results. My Query string is. $args = array( ...
3
votes
2answers
438 views

Search multiple meta keys at once

How would I modify the following SQL Query to allow me to search multiple meta keys at once? e.g. user_business AND user_about In the end I'll be searching about 40 - 50 different meta keys; or if ...
0
votes
1answer
75 views

WordPress Mysql query and Duplicate

i've a problem with mysql query on my wordpress database. I've custom fields Country and City. At moment I have this query that show all the cities of "UK" Country $querystr = " SELECT wposts.* ...
0
votes
2answers
152 views

$wpdb is queried but results don't show

I am trying to show a list of custom post types on a page template. When I view the page, instead of seeing the different posts, I see the actual page repeated. For example, If I have 5 posts, the ...
1
vote
1answer
368 views

Correct way to perform non-cacheable DB query

Consider the code function getNow() { global $wpdb; $now = $wpdb->get_var("SELECT NOW()"); $wpdb->flush(); return $now; } I am using the above method to avoid caching ...
0
votes
1answer
58 views

select a single val though a table in wordpress

The table is like this: category_id category_name category_parent_name I would like to get category_id by using category_name. I searched online, and the code is like below: $ad_cat is the ...
4
votes
2answers
2k views

How to programatically change username (user_login)?

As in the title, how to programatically change user's login? I wanted to use wp_insert_user function, but it appears that when updating current user, it doesn't change their username. Should I use ...
0
votes
2answers
885 views

add_post_meta — not working

I am trying to insert data into wp_post and wp_postmeta tables but it seems like i am doing something wrong. Here is my code: $post_data = array( 'post_title' ...
0
votes
1answer
100 views

MySQL database migration to WordPress

I have a MySQL database established for a web application I have been working on in a non WordPress database. This database has many tables with pre-populated rows for foreign keys etc. which took a ...
1
vote
1answer
336 views

How to best delete orphan wp_postmeta

I'm in the middle of doing some fairly complex queries involving metadata from a custom post type. Unfortunately if any posts are deleted the metadata stays put which complicates matters as I am ...
0
votes
0answers
125 views

Error inserting row into table

I am trying to insert a row into a table. Given below are the various functions to create table. insert data into the table- but its not working. Also given below is the sample output showing all ...
0
votes
2answers
149 views

Which query method to use? (edit- wpdb syntax problems)

I am trying to create a query in order to get all the metadata from a custom post type named match_reports that is associated with a meta_key and meta_value in another custom post type named ...
0
votes
2answers
215 views

Retriving array size from serialized data

I've a custom field in Wordpress user meta, which store data in serialized array. I want to retrieve the number of arrays. For e.g.: a:2:{blah blah} Screenshot of my table I tried the following ...
0
votes
1answer
640 views

SQL Query to select post title & post ID from a particular category

I am looking for SQL query to select post title & post ID from a particular category. I looked at wordpress table structure but it is really confusing me.
0
votes
1answer
109 views

Custom Wordpress SQL Query 4 posts per custom taxonomy

I'm currently developing a Wordpress website that has a large navigation that lists the 4 most recent posts within a hierarchical taxonomy. I dont have any experience with $wpdb, but it seems like ...
2
votes
2answers
179 views

wpdb->get_row() / get_results - is it possible to return an object instances of my own class?

Is it possible to make wpdb->get_row return an object of a my own custom class instead of stdClass?
0
votes
1answer
232 views

Plugin to create Posts and Forums then choose category and parent forum

I need to create a plugin for a customer that will help him create posts and forums and place them in a category and choose if it's a parent or a child forum. Just created a GitHub Repo for my files ...
0
votes
1answer
53 views

$wpdb->update Issue

Can anyone see what I have wrong here? $wpdb->update( $table, array( 'lat'=>$paper_lat, 'lon'=>$paper_lon ), array( 'id'=> $result=>id ...
0
votes
1answer
241 views

Show all 12 months regardless they have posts

I need to show all months for a year for an archives page. All 12 months must be shown regardless of whether or not there are posts published for a month. Like this: Year: Jan Feb Mar Apr May Jun Jul ...
1
vote
2answers
206 views

How to use a different database to list and manage comments in the backend

I need to make Wordpress use another database (not the one specified in wp-config site-wide) on the "Comments" admin backend. I then must be able to edit, approve, delete etc. comments as usual. The ...
0
votes
1answer
228 views

wpdb prepare sql problem

I have problem with wpdb prepare and sql query. If i run the query directly thru wpdb->get_results it's working fine. Here it is: $alabala_sql = $wpdb->prepare( " SELECT * FROM ...
2
votes
1answer
640 views

How can I connect to another WP database and use WP_Query?

I can connect to the other database with $db2 = new wpdb( $user, $pass, $db, $host );, but how to I get WP_Query() to use $db2? I want to be able to use the loop just the same with $db2 as I can with ...
0
votes
1answer
166 views

Best practice to limit results in get_row()?

This is my query to check if a title exists (it's in a loop, therefore [$i]). $wpdb->get_row("SELECT * FROM wp_posts WHERE post_title = '" . $titles_arr[$i] . "'", 'ARRAY_A'); Anyway, I would ...
1
vote
3answers
1k views

How to write: $wpdb->update having WHERE NOT value pair in the array

I need to update all meta keys in the postmeta table that have a value other than 0, to the value of 0. I tried this.. no love (though I cannot figure out why....): $status = $wpdb->query("UPDATE ...
0
votes
1answer
275 views

Get all sticky posts from one user through user ID

So I need to get number of sticky posts each user have and compare it to one variable. I managed to do this, but I am wondering is this the right way to do it. //Retrive all sticky posts ID ...
0
votes
1answer
131 views

Adding an orderby filter, casting postmeta with multiple keys

I am using this filter to sort my query by a date field stored as text (legacy data) add_filter( 'posts_orderby', 'my_posts_orderby_date', 10, 2 ); function my_posts_orderby_date( $orderby, $query ) ...
0
votes
1answer
111 views

WPDB Query Question with Category Only

I am trying to pull up posts from only category ID 18 with this query for a plugin I am working on but it will not work. I can not use query_posts or WP_Query in the place I am using this. global ...
0
votes
2answers
219 views

query_post and wpdb returning different results

I am trying to get the woocommerce products by category.. When I query using the wpdb it gets the product correctly which exists in the backend products list. But when I query using the query_posts it ...
0
votes
2answers
751 views

How does offset works on pagination? (get_results)

I followed this link and created my own custom query with pagination, But I don't really understand how the offset work. This pagination does not work well, and I'm getting zero value for offset: ...
0
votes
0answers
123 views

Retrieve post data via WPDB class

I'm trying to figure out doing a custom query using the $wpdb Object. I have custom type posts, event_posts, that have meta data, images, as well as event dates which are input in the post with the ...
0
votes
2answers
3k views

$wpdb returns no results with SELECT query on custom post type, works on default post type

EDIT: Adding more background info. I've coded a plugin that adds a meta box to the post page. When the post is published, the plugin will generate a random ID for the post, and insert the random ID ...
0
votes
0answers
118 views

get_query_var('paged') giving same result

I have a custom page, in that page i am using a custom select query for my search functionality. The problem is pagination not working. I used $on_page= get_query_var('paged'); for pagination. When ...
0
votes
1answer
2k views

How-To: wpdb Insert Record With Date

I am writing a plugin where I need to pre-load some data in the custom tables that I create upon Activation. My inserts have run fine thus far until I attempt to insert a record with a DATE datatype. ...
0
votes
1answer
125 views

How do I query for posts by custom meta and those that have been stickied?

I realize how clumsy and inefficient this query is but SQL is not my strong point. I use the following query to pull the latest 8 events from a custom post type called Event Posts. However, I also ...
2
votes
1answer
540 views

How to order by blog ID in this multisite 'List Blogs' custom function

I found this really cool function to list all the blogs on a multisite network install. Because the original multisite list blogs function was depreciated :/ So I am using this function below ...
0
votes
0answers
157 views

Custom query on Wordpress custom table

I am working with a custom table where some values will be inserted or updated if they already exists, I have checked and rechecked the syntax and it seems to be working fine, if I run the same query ...
1
vote
1answer
160 views

wpdb query problem to access previous 3 days posts

I am trying to get all published posts titles by author id 2 most recent by post date for the last days. Here is my query: "SELECT post_title FROM $wpdb->posts WHERE post_status = 'publish' AND ...
0
votes
1answer
739 views

$wpdb->insert Database Error Duplicate Entry Error Logging

Is there an equivalent to INSERT IGNORE in the wpdb class? As I'm fetching and inserting a twitter feed and the field in which I store the tweet ID is keyed UNIQUE, I am aware that duplicates are ...
0
votes
1answer
70 views

Create Table Failed Column Date DateType

I have a plugin that creates tables and one of them is failing and I feel like it's due to either my syntax or the fact that I'm trying to create a column with datatype DATE and not TIMESTAMP (only ...
0
votes
1answer
375 views

Custom SQL query ORDER BY term_order

I have custom taxonomy that list terms under "series" that contain posts that are also present in terms under "media_type" and where media_type is term_id 16. I want to order the list by the ...
0
votes
0answers
163 views

Filter content by custom field and category

I'm trying to filter a Wordpress request with 2 parameters. By a custom field (REGION): There are 6 regions By category: There are n-categories with 1 value per post. As a result I would like to ...