meta_key value should be name of custom field. I doubt you have fields named after each month, so it’s likely should be eventdate. meta_compare should have value that specifies a comparison operator, or just be omitted and it will default to = in that case. From this you can’t really query full event date on … Read more
No offense, but I think I’m agreeing with a commenter from your other question… You really need to read PHP, MySQL, and regular expression tutorials before you get into any of this. More importantly, you need to learn how to search a code base using regular expressions in your favorite editor, and understand the code … Read more
Should be: $where .= ” AND voted > 1″; Other notes: instead of hardcoding table names you should use $wpdb->prefix . ‘post_votes’; instead of checking in global $_GET you should declare your filters as accepting two arguments and code functions accordingly, these filters pass as second argument object that contains all of query data. Like: … Read more
Do not run this on a live site until you’re tested it on a backup or local installation and confirmed valid results, i won’t take any resposibility for lost data, should that occur. SQL Query To run from PhpMyAdmin UPDATE wp_posts SET post_content=”your_content” WHERE post_type=”post” Inside WordPress To use inside a plugin or your functions … Read more
I’m not sure about this, but the way the tables are setup, WordPress can re-use the same terms record (with the same term_id) within different taxonomies. That is, if you have a post_tag called favorites and you also have a category called favorites, it can well be that WP uses the same terms record for … Read more
Seems like trying to put “field X” into db.table.record.fieldY is too atomic, or requires a better magic wand than google can find. I’ve gone a head and just ripped the posts out wholesale and injected them into the new DB. Here’s how I did it. I hope it helps the next poor sod who finds … Read more
You got the native date( ‘Y’ ); function that will give you in that case the current year. Combine that with some if/else statement and wp_redirect( $location, $header );and you’re almost finished. It’s as easy as using user meta data $current_user to check and so on. Btw: no need to add any extra tables. Just … Read more
Issues that I see in your description: installed WordPress using their self-installer It is commonly recommended to install WordPress by hand. In a text editor, I replaced all of the local host references to the new domain URL This causes problems by breaking serialized data.
You should probably be using the WP_Query object and have it order your posts by a meta field: http://codex.wordpress.org/Function_Reference/WP_Query#Parameters Doing so will handle sorting and pagination out of the box.
You would want to create an array of those values from your spreadsheet and loop through them to call the wp_insert_category function on each one. http://codex.wordpress.org/Function_Reference/wp_insert_category