There are multiple ways to fix this. You can either remove the if-condition containing SHOW TABLES LIKE (remove lines: 117, 135 and 137, 157). That should work as the dbDelta function checks itself if the tables are already presend. Or you could just add some single quotes to the table names in the lines 117 … Read more
I am not sure about your error as well, but one thing you are doing wrong. Returning data. You should be ‘collecting’ them and then returning. $data=””; foreach ( $results as $result ) { $data .= ‘ Point: ‘.$result.’ ‘; } return $data; Try this loop.
#require_once(‘../../../wp-load.php’); #global $wpdb Comment those lines.. you don’t need it. $wpdb quite global in any template file. BTW, do you really want’s to make such form in your tempalte file? 0_o
tax_query is used to get the posts associated with certain taxonomy. {tax} (string) – use taxonomy slug. Deprecated as of Version 3.1 in favor of ‘tax_query’. tax_query (array) – use taxonomy parameters (available with Version 3.1). taxonomy (string) – Taxonomy. field (string) – Select taxonomy term by (‘id’ or ‘slug’) terms (int/string/array) – Taxonomy term(s). … Read more
It has nothing to do with $wpdb. It’s PHP parse error. print_r is a function, so you can’t do print_r $datarow; You should use print_r( $datarow ); instead.
Don’t use SQL to retrieve values from the option table, use the options API. In addition to avoiding using wrong table names (as was pointed out in the comments) you will most likely get better performance.
Ok, if i understand you clearly, then this is the solution // first get the post ids that have the breakfast food type $post_ids = $wpdb->get_col( “SELECT DISTINCT post_id FROM $wpdb->postmeta WHERE meta_key = ‘type’ AND meta_value=”Breakfast”” ); // now get the food names $stocktypes = $wpdb->get_col( “SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key = … Read more
Manipulating posts directly in database is rarely good idea, since it skips all the APIs, hooks and so on that normally participate in the process. You should use get_posts() to retrieve the list and wp_delete_post() for deletion to ensure it is done properly and there are no leftovers.
While custom SQL is sometimes what it takes, note that to address your concern for WP_Query it supports ‘fields’ => ‘ids’ argument to limit data returned to IDs (which can be easily used for count). In many cases that is reasonably efficient while more robust and future-proof in WP environment.
That is not how you would query for a featured image. This: $thumb = $wpdb->get_var(“SELECT ID FROM $wpdb->posts where post_parent=”$value” and post_type=”attachment””); Should be: $thumb = $wpdb->get_var(“SELECT meta_value FROM $wpdb->postmeta where meta_key = ‘_thumbnail_id’ and post_id = ‘$value'”); That is assuming that $value is a post ID. “Featured” images are attachments, but not all attachments … Read more