The sql tag has no wiki summary.
4
votes
1answer
2k views
Making my plugin multi-site compatible
I want my plugin to be installed on each blog and create database tables per blog. I have this code:
register_activation_hook( __FILE__, 'install1' );
function install1() {
global $wpdb;
if ...
0
votes
2answers
31 views
making php value numeric
I used some of this code from this page on Stack Overflow:
Using wp_query is it possible to orderby taxonomy?
It's about the function to be able to sort a query by a taxonomy value. Although it works ...
0
votes
0answers
12 views
Sql copy rows and change 1 value? [migrated]
How would I copy entire rows within a table and change one value?
insert into user (user_id,account_id,user_type_cd,name,e_mail_addr,login_failure_cnt,admin_user,primary_user)
select * from ...
3
votes
2answers
608 views
SELECT max(meta_value) FROM wp_postmeta WHERE meta_key='price'… stops working when value is over 999
Overview: I am not trying to return a post. I simply want the single highest value for a particular meta_value across all posts... just the value itself.
Details: I have added a custom meta_key ...
0
votes
1answer
764 views
using AJAX to run sql statement and populate dropdown
I am trying to create a search where the user select two different bit of data from databases and it them prints some results that meet requirements. I know I need to use ajax or something similar but ...
0
votes
2answers
76 views
Up/Down voting system for Wordpress
Looking in all posts with keywords "voting system, upvote, downvote", I can't find a satisfying solution for this issue, except accepting one of the available plugins, spend a lot of time undersanding ...
0
votes
1answer
23 views
SQL Bulk Move old posts by one author to another category
I'm looking to move a number of old posts by one author from one category to another category and was hoping someone could help me do this?
I figure the easiest way would be through an SQL command?
...
2
votes
2answers
130 views
What is an efficient way to query based on post_meta?
The problem I am having is when I allow users to filter posts it overpowers the database and things run extremely slow. I am unsure what the best way to query posts using meta values is. My site has a ...
-1
votes
1answer
129 views
SQL query to return categories and category parents
I have some categories which are not correctly defined.
I.e. their parents are messed up.
How can I select with SQL all categories and their parents?
0
votes
2answers
45 views
How can I get all author written content?
I have a site that needs two different tabs:
1. all author written content (Posts, comments, CTP)
2. all author followed content (categories, taxonomies, other users content)
For the first all I ...
0
votes
0answers
31 views
Get posts under a category with SQL
How can I retrieve posts under a category with plain SQL with out using WordPress native api's like get_pages?
My Wordpress table wp_terms contains a term named Restaurants.
I want to list the post ...
-2
votes
1answer
20 views
can I import an SQL dump into a wordpress.com site? [closed]
I'm trying to restore a Wordpress blog from a backup. I have an SQL dump of the database. Can I import the SQL files into a wordpress.com site or can that only be done with a wordpress.org site?
2
votes
1answer
166 views
Bulk add tag (or any sort of label) to posts who have custom excerpt
The situation is the following:
The blog as of now has 2200+ posts. In the beginning (2007/2008) I was using manual excerpts where I would put an image and a little bit of text. The manual excerpt ...
0
votes
0answers
8 views
Advice or Best Practice on setting attributes and properties for user on login
I’m working on a web application service which is going to use a lot of the built-in Wordpress functionalities but also relies heavily on some customized code and tables to create - among others - ...
0
votes
1answer
136 views
Export all posts to import as product items
Up until now, my client has been using WordPress posts as his way to display his products. I now need to export all these posts into a CSV format so that I can format the CSV file and import it back ...
2
votes
1answer
44 views
Filter WordPress posts by between parameter
How to filter WordPress posts by a taxonomy and between parameter? Consider a mobile website with "memory size" taxonomy, I need to show posts that have more than 256 mb memory and less than 768 mb.
...
1
vote
1answer
42 views
How do i export the HTML from text widgets?
I placed HTML in several text widgets which where lost after i deleted all inactive widgets and changed themes but i have found the data in the tables.
The only problem, its mixed in with all this ...
0
votes
0answers
41 views
Heavy SQL queries
I have got rid of one of SQL problems but the story isn't over. Now hoster has detected another problematic SQL query and again threatens to disable the account. Can anyone advise on what's going on ...
2
votes
2answers
79 views
How to properly sanitize strings without $wpdb->prepare?
I'm working on an advanced search (which uses custom sql queries), and the query string is formed using variables. For example, if the person checks some options, only those conditions get added to ...
0
votes
0answers
46 views
Install WordPress with SQL database
I am very new to WordPress. I didn't even know it existed until I had to do it for my work. So I started in with a WAMP server with WordPress. That worked fine until we needed multiple sites with ...
0
votes
1answer
24 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 ...
0
votes
0answers
35 views
Using HyperDB to connect to a MS SQL database
I have successfully split my WordPress database into two MySQL databases (using hyperDB). And it works well. Now I want to dive into the unknown and have one database use MYSQL and the other MS ...
0
votes
0answers
17 views
Advanced search: roles and multiple taxonomies
I have a site with custom roles, and custom taxonomies. I'm making the advanced search, where custom posts can be filtered by roles and taxonomies.
To accomplish this, I'm using my own custom SQL ...
0
votes
0answers
47 views
Special Query: Title, Terms, Content - %LIKE%
I'm working on a them theme that is search-heavy, and my users are putting huge priority on an improved search function.
I think I will have to use a special direct query to search these things:
...
1
vote
1answer
21 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 ...
6
votes
2answers
7k views
WP_Query with “post_title LIKE 'something%'”?
I need to do a WP_Query with a LIKE on the post_title.
I started with this regular WP_Query:
$wp_query = new WP_Query(
array (
'post_type' => 'wp_exposants',
...
0
votes
1answer
50 views
Woocommerce: Grab total revenue of a product over all orders
I need to display the total revenue of all orders for my products depending on if the logged-in user is the author of the product or not.
I can't use the Quantity field as a multiplier either because ...
0
votes
1answer
55 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
35 views
Convert date format in meta
I have been storing date format in meta key/value. I have been storing in this format (mm/dd/YYYY) now I need to convert that into (YYYYMMDD) SO I can run a date match in query.
Please advice how can ...
0
votes
2answers
46 views
Query posts based on parents attribute
This is the scenario:
I have multiple pages that all have a custom field named "Location"
Those pages all have child-pages with the custom field of "size_m2".
What I want is to do a normal meta_query ...
0
votes
1answer
70 views
Select from wp_post and multiple meta_value from wp_postmeta
My lack of SQL skills has stopped me in my tracks here.
I'm trying to select post_id, post_title and two postmeta values - the first has the meta_key of 'search_country' and the second a meta_key of ...
0
votes
2answers
221 views
Fetching review value using wpdb class
I'm generating an XML file using PHP for a website where they review tech products. In the XML file, I have to display the rating of products. For rating purposes, I'm using GD Star Rating plugin.
...
0
votes
0answers
16 views
Cannot insert % sign in SQL [duplicate]
I cannot insert a % sign in the SQL database. I'm using the following function:
$wpdb->query($wpdb->prepare("insert ".$wpdb->prefix."dq_category_master_catrules set ...
0
votes
2answers
50 views
Really simple query giving error in SQL syntax
I'm sure this is a simple oversight but I cannot seem to narrow it down:
global $wpdb;
$tablename = $wpdb->prefix . "icrm_folders";
$sql = $wpdb->prepare( "SELECT * FROM %s", $tablename );
...
0
votes
2answers
129 views
How to update Wordpress custom SQL Select query for custom taxonomies so that syntax is correct?
I have a Wordpress website that written by third party web developer for version 2.9 before custom taxonomies were fully implemented. We have since upgraded to latest wordpress version 3.5.x. There ...
1
vote
0answers
26 views
Meta Query And/Or
My question is very similar to Meta Query with AND & OR? . This question was answered in 2011 by @Otto.
With the exception that my logic is different.
I want to query, for example, posts with ...
0
votes
1answer
26 views
Custom $wpdb returns unexpected time based results
I am using the $wpdb class to do a custom SQL query but I am getting weird results.
Basically this is what my SQL query is supposed to do
Retrieve the titles of post_types 'question' only if they ...
0
votes
0answers
45 views
Custom Wordpress Meta Query
I have a post type (course) that has some meta data associated with it, namely the following two:
City and State
The two pieces of data above are stored in the postmeta table, with meta_keys ...
0
votes
2answers
30 views
Create a new page for each form selection
I have a got custom page template which displays a drop down box that has list of countries.A user selects the box and clicks sumbit.Page then then displays the relevant details for that country .IT ...
1
vote
1answer
27 views
Fetch all Posts where logged in user has commented
I'm not good at sql queries so the question is:
How do I list all the Posts where logged in user has left the comment?
I guess it's kinda obvious that redundancy is unwanted in case user posted ...
1
vote
4answers
3k views
Most efficient way to get posts with postmeta
I need to get a bunch of posts with their metadata. Of course you can't get metadata with a standard posts query, so you generally have to do a get_post_custom() for each post.
I'm trying with one ...
0
votes
0answers
36 views
posts_per_page is set to 1, returns 50 posts
I'm trying to get the latest post in a custom post type:
$query = new WP_Query(array(
'post_type' => 'some_custom_post_type',
'posts_per_page' => 1,
'orderby' ...
0
votes
0answers
34 views
Not Creating New Database Table [closed]
I've successfully created tables with previous plugins I've messed around with, but I can't seem to figure out exactly what's wrong with this. Hopefully it's an easy fix.
//CREATE ...
0
votes
2answers
113 views
Assign a list of categories with a parent category
I imported hundreds of locations and other categories. Now I have a list of locations in categories to which I would like to assign the "Location" category as its parent.
I have tried sql but the ...
0
votes
1answer
121 views
Using color schemes with Color Picker
What I'm doing
User interface to change website colors - User can change colors individually (like menu color, footer color, content color), or use color scheme that will change all colors (values ...
0
votes
1answer
2k views
Retrieving custom fields with $wpdb->get_results
I'm trying to use $wpdb->get_results to retrieve an array of all posts including custom fields. I can retrieve the meta_key and meta_value columns like this:
[meta_key] => state [meta_value] ...
0
votes
1answer
34 views
learn to run wpdb class
I want to learn how to run commands through WP rather than SQL commands
I have a SQL command:
SELECT
post_id,
(select meta_value from wp_postmeta where meta_key = a 'geo_latitude' AND x.post_id = ...
0
votes
1answer
37 views
Print page content with formatting when doing custom SQL query
I guess there's a simple solution for this but couldn't find any.
I'm trying to fetch 3 pages and show them on footer. The problem is that every page is shown as text without formatting which means ...
1
vote
1answer
44 views
Wordpress Custom post query sorting does not work
I created a custom WP query to collect products that have 3 different taxonomy values in them and sorted them by price using the following:
$my_products = new WP_Query(
array(
...
0
votes
2answers
144 views
SQL query to get posts from multiple categories but not in a category
I need to get the last posts' ID and the post_tile within categories 1 and 2, and exclude those within category 3. It must be SQL, because if I use WP_Query it retrieves too much info and I only need ...
