Issue with custom PHP query

Hi ladydelaluna.

As mentioned above, I’m not familiar with the construction of the Studiopress WordPress theme. When reading your original post above, the process looks, to me, like this:

Goal: Display images of other posts in the same category(s) as the post currently being viewed.

And the process:

1. If the page being viewed isn’t a single post page, display the images as they are currently.

2. If the page being viewed is a single post page, do the following:

2.1 Determine the IDs of the categories the current post is categorised under.

2.2 Use a custom SQL query to pull the values of all other posts in hte same categories into an array.

2.3 If the query returns no results, display the images as they are on the homepage.

2.4 Otherwise, if the query returns results, loop through and display the images within the results only.

Using the first snippet of code above, we can modify it to read as follows:

<?php
if ( is_single() ) {
// DO CHECKS FOR CATEGORIES, ETC
} else {
// DISPLAY IMAGES AS THEY ARE CURRENTLY
}
?>

Knowing this, we’ve solved step 1.

Step 2 is clear, once the code is in place. The first part looks, in my mind, like this:

<?php
	$categories = get_the_category();

	$category_ids = array();

	foreach ($categories as $category) {
		$category_ids[] = $category->cat_ID;
	}

	global $wpdb;

	$sql = "SELECT
				ID, post_title
			FROM
			" . $wpdb->prefix . "posts
			JOIN
			" . $wpdb->prefix . "term_relationships ON ID = object_id
			WHERE
				post_type = 'post' AND post_status = 'publish' AND ID != " . $post->ID . "
			AND
				(";

	for ($i = 0; $i < count($category_ids); $i++) {
		$sql .= " term_taxonomy_id = " . $category_ids[$i];

		if ($i < count($category_ids)-1) {
			$sql .= " OR ";
		}
	}

	$sql.= ") GROUP BY ID ORDER BY post_date ASC";

	$rs = $wpdb->get_results($sql, ARRAY_A);
?>

Essentially, the above code handles steps 2.1 and 2.2. Steps 2.3 and 2.4 are a matter of running an IF statement that looks something like this:

<?php if (empty($rs)) {
// DISPLAY NORMAL IMAGES
} else {
// DISPLAY CATEGORY SPECIFIC IMAGES
}
?>

As I am unfamiliar with how the images are selected from the database and displayed, I am unable to code the image display itself. If this is using a WordPress custom field, it should have functions such as get_post_meta() in the code snippet, which should be quite clear to decipher and work through. 🙂

I hope this helps. 🙂

Awesome! Glad I could help. 🙂

Did this solution work out?