The join-tables tag has no wiki summary.
0
votes
1answer
26 views
Reordering content using a meta value
I've got this theme where you can add posts of type "portfolio", and I want to be able to reorder them up. I've added a custom meta field called "position" and I've set already those values. All good. ...
0
votes
1answer
125 views
Wordpress SQL JOIN query
Hi
Im trying to run 2 querys in the same query call.
// send the query
global $wpdb;
$commentQ = "SELECT * FROM $wpdb->comments " . $whereClause . $orderBy;
$comments = ...
1
vote
2answers
140 views
Join new table with SQL query
I created a plugin with a new table (wp_soundcloud) and I need to retrieve the data from that new table along with the post data.
Here is my query:
$querystr = "
SELECT $wpdb->posts.*,
...
0
votes
1answer
102 views
List author's posts with SQL
I want display authors'posts with the code below but authors' name aren't showing.
What is wrong?
<? // query test
$qry = $wpdb->get_results( $wpdb->prepare("
SELECT *
FROM $wpdb->posts
...
-1
votes
1answer
82 views
Custom wordpress SQL statement for a website
I'm trying to link specific columns from a few standard tables in a wordpress database. I specifically want to see a view/table that includes:
post title
post content
guid
meta value = image url
...
0
votes
2answers
114 views
Joining tables not working in the post editor page
I am developing a plug-in which stores data in a custom table and is joined onto the wp_posts by the post's the id. I then use the posts_join and post_fields filters to join my table and be able ...
0
votes
1answer
931 views
Join inside a wpdb query.. confused!
I need to get a return from a query that provides me with email, username or nicename as well as post title based on author id.
The query is to run once daily via cron and look for posts that have ...
