The answer really lays in the first line SELECT post_title, ID, MIN( CAST(wm.meta_value AS UNSIGNED)) AS price – here you cast to UNSIGNED which is integer, and this cuts of your decimal part. So the solution is just replace UNSIGNED with DECIMAL(10,2) or FLOAT And result code will look this way with FLOAT $pts = … Read more
) bracket missing in last condition. (i.e AND (b.meta_key = ‘usage_count’ AND b.meta_value=”0″”); ) $rowcount = $wpdb->get_var(“SELECT COUNT(*) FROM $wpdb->postmeta AS a, $wpdb->postmeta AS b WHERE a.post_id = b.post_id AND (a.meta_key = ‘customer_email’ AND a.meta_value LIKE ‘%[email protected]%’) AND (b.meta_key = ‘usage_count’ AND b.meta_value=”0″)”); echo $rowcount;
They give different results because those queries are not the same. They have different latitudes and longitudes. For example the latitude in one is ‘43.2832512’ but in the other it’s 43.5586. They aren’t even the same data type. The long/lat in your prepare statement is for a park to the east of marseille, the one … Read more
$wpdb->get_results() returns an array of rows from the queried table and not a mysqli_result object, so you can just use foreach like so: $result = $wpdb->get_results( $sql ); foreach ( $result as $row ) { echo $row->correct_count; // … } And by default, each row is an object with the columns (<column name> => <column … Read more
It looks like this is the new part of this query causing the problem, is that right? (SELECT term_taxonomy_id FROM wp_BOMEGAterm_relationships WHERE object_id = p.ID) AS categories If so the error message is clear: a sub-select in this query should only return one row. If it returns more than one row it doesn’t know how … Read more
(As you said, this is not specifically a WordPress question except for how to hook into WordPress functionality with users. Here are some thoughts) I think there are some design questions you need to have clear in order to make it easy figuring out the order to build things: Users signing up and signing in … Read more
There are many ways you can achieve this… In your instance, as you pointed out $wpdb, here is the possible ways you can achieve this: 1. Use $wpdb::query You can run this query directly using $wpdb’s query method as: add_action(“init”, “username_query”) function username_query(){ global $wpdb; $prefix = $wpdb->prefix; $query = “UPDATE `{$prefix}wp_users` SET `user_login`= ‘new-admin-name-here’ … Read more
This is more of a MySQL question, but I think your design is fine and is unlikely to create any database problems, even for a lot of rows (up to 1,000,000). The reason for this is: Why this is fine Nearly everything you do with this table should be writes, and there will only be … Read more
I finally got the solution. Below SQL Query gets the list of all categories with it’s ID from WordPress table – SELECT wp_term_taxonomy.term_id, wp_terms.name FROM wp_term_relationships LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) LEFT JOIN wp_terms ON (wp_terms.term_id = wp_term_taxonomy.term_taxonomy_id) WHERE wp_term_taxonomy.taxonomy = ‘category’ GROUP BY wp_term_taxonomy.term_id order by wp_terms.name Hope this could help others.
Your message_id is a BIGINT whereas the id of wp_ccwwhsh_sent_messages is INT. Replace BIGINT by INT and try again. The error message, unfortunately, isn’t very helpful.