I see a few things that you might try to shortcut things: Currently a Multisite network only allows one site ID, according to the Codex page for $wpdb->siteid. Also, the site ID is defined in your wp-config.php file as a constant, BLOG_ID_CURRENT_SITE. So any reference to $wpdb->siteid can be replaced by BLOG_ID_CURRENT_SITE. Look into the … Read more
Add the next lines of code to functions.php file within active theme to start session. function example_login() { if ( ! session_id()) { session_start(); } } add_action( ‘init’, ‘example_login’ ); and then Use $_SESSION to store the value of $post
$wpdb->get_var will do exactly what the name suggests– return a single value. So this: $sum = $wpdb->get_var(“select sum(first), sum(second) from sums_test where id > 1”); var_dump($sum); Will return the result of sum(first). The rest of the result is lost (though cached I believe). The method you want is get_row which will return a complete row … Read more
The problem is that you’re not assigning a unique ID to each popup element. HTML element IDs should be unique, and each time you call animatedcollapse.show( ‘script-sample’ ) it will target the first element with the id “script-sample”. What you could do is assign a unique ID to each popup element by using the post … Read more
your are comparing time against wrong time string: change: ‘meta-value’ => date(‘Y-m-d’, strtotime(‘-6 hours’)), //value of “order-date” to this ‘value’ => date(‘m-d-Y’, strtotime(‘-6 hours’)), //value of “order-date” because your time string is in m-d-Y format and you are check against Y-m-d which is wrong. NOTE if above trick doesn’t work then i suggest you to … Read more
I think you are jumping a gun with custom SQL, complexity of this seems still in realm of WP_Query. Even if not it’s a good idea to start with it to have more solid base for custom SQL. If I try something like this: $meta_query = array( array( ‘key’ => ‘body_type’, ‘value’ => ‘bt’ ), … Read more
I manage to work my problem. For those who seek the same answer, just run this query INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT wp_posts.ID, ‘video_desc’, ‘Description here’ FROM wp_posts WHERE wp_posts.post_status=”publish”;
You can use the name parameter in your arguments ex: <?php $args = array( ‘post_type’ => ‘product’, ‘posts_per_page’ => 12, ‘name’ => ‘slug’ ); but this will only match the post with that same slug.
I would recommend that you use WP_Query for this one: $categories = get_categories( ‘child_of=83’ ); foreach ( $categories as $category ) { echo ‘<h3>’ . $category -> name . ‘</h3>’; echo ‘<ul>’; // create a WP_Query that retreives all posts from the specified // category which is older then 1 week $args = array( ‘cat’ … Read more
You might be able to use the query filter hook See this WPSE answer Basically, you can do something like: add_filter( ‘query’, ‘your_filter_function’ ); function your_filter_function($query_sql) { // do something to $query_sql return $query_sql; } This will get called for every query, so you’ll need to test $query_sql to make sure it’s the query you … Read more