http://wordpress.org/support/ WordPress › Support Topic: MySQL query / Need list of subcategories en Thu, 26 Nov 2009 10:43:24 +0000 http://wordpress.org/support/topic/226555#post-1005435 Wed, 04 Mar 2009 18:24:26 +0000 brockangelo 1005435@http://wordpress.org/support/ <p>Thanks - this is exactly what I was looking for. </p> http://wordpress.org/support/topic/226555#post-930065 Thu, 18 Dec 2008 18:38:20 +0000 areimann 930065@http://wordpress.org/support/ <p>Thanks...that did work....but not on my local box (didn't have an children there....) oops!</p> <p>thanks</p> <p>everything works </p> http://wordpress.org/support/topic/226555#post-930060 Thu, 18 Dec 2008 18:34:05 +0000 filosofo 930060@http://wordpress.org/support/ <p>That should work. Try var_dump($children); to see if anything's being returned. </p> http://wordpress.org/support/topic/226555#post-929968 Thu, 18 Dec 2008 16:33:50 +0000 areimann 929968@http://wordpress.org/support/ <p>That sounds great, thanks. But how do I echo that list?</p> <p> $children = get_categories(array('parent' =&gt; 41));<br /> foreach ($children as $child) {<br /> echo $child-&gt;cat_name;<br /> }</p> <p>doesn't do anything...what am i missing? </p> http://wordpress.org/support/topic/226555#post-929357 Thu, 18 Dec 2008 03:01:01 +0000 filosofo 929357@http://wordpress.org/support/ <p>Why not use the WordPress API? </p> <p><code>$descendants = get_categories(array(&#39;child_of&#39; =&gt; 41));</code></p> <p><code>$children = get_categories(array(&#39;parent&#39; =&gt; 41));</code></p> <p>Note that $children will contain just the immediate child categories, but $descendants will include all descendant categories, including grand-children, great-grandchildren, etc. </p> http://wordpress.org/support/topic/226555#post-928920 Wed, 17 Dec 2008 20:10:41 +0000 areimann 928920@http://wordpress.org/support/ <p>I am looking for the query to just list the subcategories (or children) of wp_terms.term_id = 41</p> <p>I need to format these is a very odd structure.</p> <p>Can anyone help? </p>