You just need to return the user ID in the main select and use that as the author ID. Also I probably confused the issue previously by using echo with commas (separate arguments) rather than dots (one concatenated argument). $weekly = $wpdb->get_results ( ” SELECT u.ID, ( SELECT CONCAT_WS(‘.’, SUM(CASE WHEN p.post_date > ‘$date2’ THEN … Read more
This is a php logic / variable issue. You output $fullname whether or not it has been set inside that iteration’s foreach. So for projects that never enter the foreach to set $fullname, it still contains whatever the last iteration had set it to. Set it to an empty string before the foreach so it … Read more
Check out the codex on wpdb. In your case, get_row returns the first row of the result set as an object. There’s no need for any mysqli_* functions when using $wpdb. if ( $result2 ) echo json_encode( $result2 ); And a heads up for SQL injection – use the prepare method: $wpdb->get_row( $wpdb->prepare( “SELECT * … Read more
You will have to define post order in second SQL query too. Try this one. // get years that have posts $years = $wpdb->get_results( “SELECT YEAR(post_date) AS year FROM wp_posts WHERE post_type=”post” AND post_status=”publish” GROUP BY year DESC” ); foreach ( $years as $year ) { // get posts for each year $posts_this_year = $wpdb->get_results( … Read more
As you can guess from version number this code is ancient. So ancient in fact that var keyword is from PHP 4 and is deprecated in PHP 5 (considered synonym of public for backwards compatibility). So inline doc hints it is private because back then there was no actual property visibility in PHP language. So … Read more
My SQL knowledge is quite bad, I should admit, so I’m going to use a non SQL way to achieve this. Here is my idea: Use pre_get_posts to alter the query variables before the main query is executed. As all of the query variable has been set by the time pre_get_posts run, you can simply … Read more
$wpdb->prepare() is only necessary when trying to insert user input into a SQL query. If it’s a “static” SQL query, it’s not necessary.
Simple, hook on the query filter and structure that “unstructured” sql data. Parsing SQL is annoying but can’t be that difficult. Of course some queries are ran before plugins are loaded as you do need to get the list of active plugins and active theme before including their file. And if you need to access … Read more
Why do your own database queries? Use the WP functions to do it for you. $empid = (int) $_REQUEST[’empid’]; $name = get_user_meta($empid, ‘first_name’, true) . ‘ ‘ . get_user_meta($empid, ‘last_name’, true);
By default, wordpress get_results return a numerically array of objects, so to use echo to print your data yo should do something like; foreach($myrows as $line){ echo $line->question; }