Customized Query in Wordpress

by Mark Marucot on September 18, 2007

HTML:

<ul>
<?php
$get_children = $wpdb->get_results('SELECT * FROM your category table WHERE category_parent = "The cat_ID of the parent that you want"');
foreach ($get_children as $child) {
echo '<li><a href="./?cat='.$child->cat_ID.'" title="View all posts filed under '.$child->cat_name.'">'.$child->cat_name.'</a></li>';
}
?>
</ul>