Thanks to @Hobo’s answer which gave me the clue for moving pm2 condition to the join statement SELECT p.ID, p.post_content, p.post_title, p.post_excerpt, pm1.meta_value as meal_date, pm2.meta_value as meal_plan, t.name as meal_type FROM wp_posts AS p LEFT JOIN wp_term_relationships AS r ON (p.ID = r.object_id) INNER JOIN wp_term_taxonomy AS x ON (r.term_taxonomy_id = x.term_taxonomy_id) INNER JOIN … Read more
How to get image path from id using SQL
no result returns when using $wpdb->get_results with where clause
I will start with the question. From the sql error output we see this SELECT * FROM WHERE dbID = 719 This tells us that $sanitized_search_language has no value, so check it first. Now for the BIG problem with this query! You used get_results with a sql query that has variables as is, get_results doesn’t … Read more
How to fetch WordPress database values in JavaScript widget
Got it to work by formatting the $dateAndTime string like this before binding it: $formattedDateAndTime = date(“Y-m-d H:i:s”, strtotime($dateAndTime));
That error itself is not specific to WordPress, which means even if you used phpMyAdmin or the MySQL command line interface to execute the same query with the dates not enclosed in quotes, you would still get the same error. Therefore for string literals like the 2021-06-01 04:00:00 (a DATETIME literal) in the error, you … Read more
How can I connect to a second database and still be able to use wp functions like get_post_types()?
How do I get database rows from a custom table using wpdb?
There are several issues in your function. Do not use backticks in the sql. Don’t put quotes around field names. You use get_results with LIMIT 1 when you only need the value from a single column in a single row. And you use $meme_sku instead of… $post_sku ? Just guessing with this example, it might … Read more