Custom Query for Taxonomy

Question

What is the correct wpdb custom query for this:

taxonomy=pa_main-genre&post_type=product&orderby=name&order=asc

Basically i am trying to do is,list all the terms for pa_main-genre. Thank you very much

jessica · Answer 1 · 2012-06-19 18:27:42Z

up vote 0 down vote

If you want a list of the terms, use get_terms():

<?php
$terms = get_terms('pa_main-genre', array('orderby' => name,));
?>

answered Jun 19 '12 at 18:27

jessica
839210

	How about using wpdb class? Like <?php $wpdb->get_results('query', OBJECT_K); ?> – johndavedecano Jun 19 '12 at 18:32
	@johndavedecano what would be the reason to use `$wpdb`? Does `get_terms()` not return what you need? If so, then I may have misunderstood your question. – jessica Jun 19 '12 at 18:34
	I think there is something overriding that function. So i need to use a custom sql query to retrieve the taxonomies terms – johndavedecano Jun 19 '12 at 18:43

1 Answer