You have the where clause of the query in the wrong place. Your query should be written like this: $query= “SELECT * FROM files WHERE custom > 0 ORDER BY id DESC LIMIT $from, $site”; As specified here https://dev.mysql.com/doc/refman/8.0/en/select.html in the MySQL reference.
You should use prepare only when you’re using SQL query – this function takes query and params and returns a safe SQL query filled with given params. Its result is a SQL query. So you can (and should) use it whenever you’re creating a SQL query and put some params in it. With $wpdb->delete or … Read more
What you’re doing is safe. However, some notes: See the WP_User_Query class in the Codex. This is the, “official,” way to do something like this, although you’ll get an integer-indexed array of WP_User objects. Instead of the ARRAY_A that you’ve specified. You probably don’t want _my_table, unless your table is called something like wp__my_table (note … Read more
Your SQL doesn’t look right. It should be more like $prep = $wpdb->prepare( “SELECT * FROM {$table_name} WHERE name LIKE ‘%s'”, $city );
Just noticed that you are missing a prepare. Your code should look like this $results = $wpdb->query($wpdb->prepare(‘UPDATE points SET upvotes = upvotes + 1 WHERE userid= %d’, $theDynamicUserID));
Are you moving WP to new server and domain or new server only? I mean will URL remain the same or will be changed? There are several things that can go wrong and it is hard to say from details you provided. Basically: there might be something wrong with your new WP installation, had you … Read more
This removes the posts and all associated post meta data: DELETE a,b,c FROM `wp_posts` a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_author=”0″; Replace the 0 with the ID number for the post_author you wish to remove.
Your log shows that MySQL is performing a linear scan of all table records to get the necessary row – this is because there is no index for guid Assuming wp_rb_posts is just the normal posts table with a slightly modified prefix, then you can just add an index for that field, and you’ll see … Read more
You just have to modify your query to get only first 25 matches SELECT * FROM $wpdb->blogs WHERE spam = ‘0’ AND deleted = ‘0’ and archived = ‘0’ and public=”1″ limit 25. The result is already order by id what is incremented automatically, you don’t have anything to bother about there. Also please note, … Read more
Look at your conditions: WHERE ( ( (meta_key=’user_school_subjects’ AND meta_value LIKE ‘%history%’) OR (meta_key=’user_professional_courses’ AND meta_value LIKE ‘%history%’) OR (meta_key=’user_language_tutoring’ AND meta_value LIKE ‘%history%’) OR (meta_key=’user_music_tutoring’ AND meta_value LIKE ‘%history%’) ) AND (meta_key=’user_gender’ AND meta_value=”male”)) There is no way that you can have a meta key matching one of these– user_school_subjects, user_professional_courses, user_language_tutoring, user_music_tutoring … … Read more