Your query is incorrect in the first place because you’re not doing the join correctly. What you’re actually selecting with that query is just all the postmeta’s autor fields, without regards to whether the post is published or not. Here’s the corrected query. SELECT meta_value AS autor FROM wp_posts JOIN wp_postmeta ON (wp_postmeta.post_id = wp_posts.ID) … Read more
I guess the problem is a pretty simple one. You didn’t show the whole code, but I guess the problem is that you’re saving the insertion for some unknown reason as string into a var named $stat. Everytime you fill the var with a new query you’re overwriting your var. You should use $stat .= … Read more
$wpdb->get_results() returns good result only in first foreach iteration
$post_this_month = $wpdb->get_results($wpdb->prepare(” SELECT key1.ID, key1.post_title, days.meta_value as days FROM $wpdb->posts key1 INNER JOIN $wpdb->postmeta days ON days.post_id = key1.ID AND days.meta_key = %s INNER JOIN $wpdb->postmeta startdate ON startdate.post_id = key1.ID AND startdate.meta_key = %s INNER JOIN $wpdb->postmeta enddate ON enddate.post_id = key1.ID AND enddate.meta_key = %s WHERE days.meta_key = %s AND startdate.meta_value <= … Read more
You can use the function get_posts to get all your post, and then use a foreach cycle to replace the img tags using the regex you posted and then use wp_update_post to change post content: function remove_images_form_past_posts() { if ( get_transient(‘images_removed_from_past’) ) return; $posts = get_posts(‘nopaging=1’); if ( $posts ) { foreach ( $posts as … Read more
How can I fix this? You can’t, but it isn’t broken. You are telling prepare to use a string. A string will be quoted. It isn’t meant to generate MySQL syntax, which is what you are asking it to do. Your tablename is more a MySQL command or keyword than a string value. That isn’t … Read more
You would create your own dp.php file in the wp-content directory; if you define $wpdb in there, it will replace WordPress’s default $wpdb object. It’s not listed on the Pluggable Functions list (not a big surprise, as $wpdb is a class, not a function), but it seems similar in concept. Also, if you haven’t read … Read more
There are a couple things you need to do differently to make this work well. Make sure you’re setting $wpdb to the global. Use $wpdb->prefix instead of hard-coding wp_. Wrap your variables in curly braces. Use $wpdb variables instead of table names, like $wpdb->comments. Always always always use $wpdb->prepare() before performing a query. Using $wpdb->prepare() … Read more
Please take a look at the Codex to see how to prepare your statement: // Example straight copy-paste from Codex $metakey = “Harriet’s Adages”; $metavalue = “WordPress’ database interface is like Sunday Morning: Easy.”; $wpdb->query( $wpdb->prepare( ” INSERT INTO $wpdb->postmeta ( post_id, meta_key, meta_value ) VALUES ( %d, %s, %s ) “, 10, $metakey, $metavalue … Read more
OK, so here is how you should to this proper way… In your template file you put your form: <form id=”myForm” name=”myform” action=”<?php echo esc_attr( admin_url(‘admin-post.php’) ); ?>” method=”POST”> <input type=”hidden” name=”action” value=”save_my_custom_form” /> <select id=”brandSel” size=”1″> <option selected=”selected” value=””>– Select Brand –</option> <option>Abba</option> <option>AG Hair</option> </select> <input type=”submit” value=”submit” /> </form> And in functions.php … Read more