September 2007

The practical example, outlined below, demonstrates a process of selecting all posts with a particular Custom Field value stored, and displaying them in a Page based on a Page Template. http://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query

PLAIN TEXT 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>