Database

Creating a “forum” – showing last post or last commented post

by

You can add the standard taxonomy joins to the query: global $wpdb; $cat_id = 79; // Whatever. $sql = ” select wp_posts.*, coalesce( ( select max(comment_date) from $wpdb->comments wpc where wpc.comment_post_id = wp_posts.id ), wp_posts.post_date ) as mcomment_date from $wpdb->posts wp_posts JOIN $wpdb->term_relationships AS tr ON wp_posts.ID = tr.object_id JOIN $wpdb->term_taxonomy AS tt ON tr.term_taxonomy_id … Read more

How do i get value from wp_postmeta?

by

Try this : $value = get_post_custom_values( ‘banda_postmeta’, $post->ID ); $value = unserialize(“$value”); print_r($value); echo $value[‘social_networks_url’][‘twitter_url’]; Your social_networks_url are blank, so try echoing these values, it will echo the value. echo $value[‘page_builder_settings’].”<br />”; echo $value[‘date_of_birth’].”<br />”; echo $value[‘location’].”<br />”; Output : array (size=7) ‘social_networks_url’ => array (size=9) ‘twitter_url’ => string ‘wr’ (length=2) ‘facebook_url’ => string ” … Read more

using same mysql user with many databases

by

Well it’s really not good practise, but this depends on how you’re accessing the other databases. For example, I have a server that hosts 10+ different WordPress sites. I have two options for connecting to the databases: Use the root login in all my wp-config.php files as it’s easier Create a user and logins associated … Read more

MySQL database gives blank page (white screen of death)

by

From the looks of it, you should be changing the pre-existing urls from /www.mypage.no to /localhost The /var/www is part of the file path normally (though i suppose you could potentially set the server up that way…), so more than likely wordpress thinks it is at /var/www relative to the web root instead of /. … Read more

How can I work on a database along side a client?

by

You’ll need to make some modifications to wp-config.php. Add the following so WordPress picks up the domain automatically based on the environment: define( ‘WP_SITEURL’, ‘http://’ . $_SERVER[‘SERVER_NAME’] ); define( ‘WP_HOME’, ‘http://’ . $_SERVER[‘SERVER_NAME’] ); Now we need to make WordPress a little more portable by having it determine which host to use based on which … Read more