The sql tag has no wiki summary.
0
votes
1answer
38 views
post id not displaying
I have used this code in header.php
### get the author info
global $current_user;
get_currentuserinfo();
$authorid = $current_user->ID;
### get the last post id using author id
...
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
2answers
227 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
1answer
170 views
Remove password protection from all posts
So I messed up my blog (QBobble). I had an SQL backup, fortunately, so I reinstalled Wordpress, and imported my SQL database.
Unfortunately, it password protected all of my posts. I know that I can ...
0
votes
3answers
90 views
quotes problem in very simple sql
I just simply want to execute a SQL sentence inside of a post (i am using EXEC-PHP widget for that).
The problem are the quotes when i want to do something like
$my_name='hello'
"select * from ...
0
votes
1answer
55 views
Exporting by table
I am using PHPmyAdmin to move a site.
My site is too large to use the single file export/import method. (I know how to do it, it works fine on smaller sites.)
It seems the only thing working for me ...
0
votes
1answer
73 views
How can I get posts from 9/13/11 to today with SQL? [closed]
I have been working with a client to redesign his site and we are at the stage where we are going live, except I'm running into a little problem. Time is of the essence, as the deadline is mid-day ...
0
votes
2answers
114 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
2answers
218 views
Wordpress Categories: Function using custom SQL to return array of specific category IDs
I'm developing a custom theme which uses categories for positioning, all of which begin with an underscore (e.g. _position1). I have an SQL query as below to get a list of these categories (those ...
0
votes
2answers
326 views
wordpress sql posts query won't display the latest post in a specific category
Hi I tried to display 5 posts titles from a specific category
also show the date, but it won't display the most recent one
that just published, I had to change the recent post date 2 months
so it'd ...
0
votes
2answers
327 views
Display latest post from Wordpress Featured Category that is also in X,Y,or Z categories
I want to display the latest post from a "featured" category (id=1) that may also be in either X category, Y category, or Z category (id=2,3,4 respectively). Note, there are other posts in categories ...
0
votes
1answer
146 views
How to export 2 week's worth of posts
I need to export the last two week's worth of blog posts from one site into another site, including all meta data and post author info.
Is there a good SQL statement to do this, or a plugin that ...
0
votes
1answer
512 views
How to retrieve sticky post in raw sql?
How I could made a sql query who retrieve all the sticky post in a wordpress database? This is because we use a new app over the old wordpress website database, and I don't know where Wordpress ...
0
votes
1answer
184 views
How can I convert everything from category X to have post format Link
My "links" come in from Windows Live Writer, from a perl based delicious sync directly to the database and who knows where from. They all have in common that the category is 'Daily-Links'. So I think ...
0
votes
1answer
404 views
latency problems with wordpress install (from SQL import)
I develop wordpress sites for a living, and today I am experiencing something that I haven't yet come across: Extremely slow load times / latency problems. You can view the site here: ...
0
votes
1answer
639 views
Can Anyone provide an example of RAW SQL for SELECTING posts by 2 or more tags
I need a RAW SQL, as I am working from different platform with WordPress Database.
When I run example.com/tag/first+second, WordPress runs a query SELECT post_id, meta_key, meta_value FROM ...
0
votes
1answer
588 views
Troubles about insering a POST with a SQL query, post_status
I 'm using wordpress 3.0.5
I have to use sql for create post, here is my SQL query:
$req = $bdd->prepare('INSERT INTO wp_posts ...
0
votes
1answer
2k views
Overriding default calendar to show posts from a category
I'm trying to modify the default WP calendar (get_calendar()) so that it shows posts from a specific category and then use that as a shortcode.
Here's what I've done:
Copied across the ...
0
votes
1answer
39 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
1answer
11 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
24 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 ...
0
votes
0answers
31 views
Ranking authors by post meta value
I have custom post-type with custom post-meta and i want to rank authors by post meta value.I can show the SUM of a meta value on author page with this code
<? php
$points = ...
0
votes
1answer
40 views
WP_Query with several meta_query-statements and order by meta_value
This is my query:
$the_query = new WP_Query(
array (
'post_type' => 'pass',
'posts_per_page' => '-1',
'post_status' => 'publish',
...
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 ...
0
votes
1answer
33 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?
...
0
votes
0answers
33 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 ...
0
votes
0answers
9 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
0answers
46 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 ...
0
votes
0answers
60 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
0answers
41 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
19 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
56 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:
...
0
votes
1answer
69 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
0answers
54 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
52 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
89 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
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
142 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 ...
0
votes
0answers
58 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
33 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 ...
0
votes
0answers
42 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
38 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
1answer
38 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
2answers
131 views
Error establishing a database connection After Copy localhost wordpress site (with site url directly to hosting server's url before copy)
I have a localhost site that I heard I can migrate the site by just copy and paste the whole site from local to host if I changed WordPress Address (URL) and Site Address (URL) to my current hosted ...
0
votes
1answer
43 views
finding out the top 5 source ( source is a custom taxonomy ), in a given category
The client I'm working with have thousands of articles and media ( audio/video ) files.
To WordPress, all are posted by Author ID 1, which we named as STAFF.
All the content though in reality has ...
0
votes
1answer
97 views
Export / import Wordpress database
Is there a proper way of exporting and importing a big WordPress MySQL database to a new database?
When I tried to do that in the standard way I run into 2 issues:
All widgets disappeared and I had ...
0
votes
1answer
83 views
Bulk move (or copy) from a custom field to the post content?
I need to move (or copy) the contents of a custom field into the main post body, replacing any existing content.
I need to do this for a few hundred posts...Is there a quick way of doing this?
I can ...
0
votes
2answers
53 views
Query is not work
I use this codes in my functions.php to track post views.
/* Functions to track Post Views*/
function getPostViews($postID){
$count_key = 'post_views';
$count = get_post_meta($postID, $count_key, ...
0
votes
3answers
194 views
Migrated to Namecheap, now Trouble with Database & wp-config [closed]
I have been using a free web host while I set up my WP site. Now that it's all done I went and bought hosting from Namecheap.
I uploaded the site and WordPress and everything seems to look fine, but ...
0
votes
1answer
792 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 ...
