SlightlyAmiss

The following block of code gets me a lot closer to where I want to be:

<?php
$category_ids = get_all_category_ids();
foreach($category_ids as $cat_id) {
  $cat_name = get_cat_name($cat_id);
  echo $cat_id . ', ';
}
?>

Is there some way to stipulate that I only want the category IDs to be children of parent cat, in my case 31?

Thanks!

I figured out how to modify the first block of code in my original post to output only sub-categories of a specified ID. I’ll post it here in case anyone needs reference.

<?php
$categories = $wpdb->get_results("
	SELECT DISTINCT(terms.term_id) as ID, terms.name, terms.slug
	FROM $wpdb->posts as posts
	LEFT JOIN $wpdb->term_relationships as relationships ON posts.ID = relationships.object_ID
	LEFT JOIN $wpdb->term_taxonomy as tax ON relationships.term_taxonomy_id = tax.term_taxonomy_id
	LEFT JOIN $wpdb->terms as terms ON tax.term_id = terms.term_id
	WHERE 1=1 AND (
		posts.post_status = 'publish' AND
		posts.post_author = '4' AND
		tax.taxonomy = 'category' AND
                tax.parent = '29'
                )
	ORDER BY terms.name ASC
");
?>
<ul>
	<?php foreach($categories as $category) : ?>
	<li>
		<a href="<?php echo get_category_link( $category->ID ); ?>" title="<?php echo $category->name ?>"><?php echo $category->name ?></a>
	</li>
	<?php endforeach; ?>
</ul>

Change the tax.parent value to the parent category’s ID. In my case, the list of sub-categories all needed to spawn from parent category 29.

Hope this helps!