Tagged Questions
0
votes
1answer
118 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
134 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
894 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 ...
