function display_categories($id = null, $level = 0) { global $wpdb, $category_data; if (is_numeric($id)) { $category_sql = "SELECT * FROM `" . $wpdb->prefix . "product_categories` WHERE `active`='1' AND `category_parent` = '" . $id . "' ORDER BY `id`"; $category_list = $wpdb->get_results($category_sql, ARRAY_A); } else { $category_sql = "SELECT * FROM `" . $wpdb->prefix . "product_categories` WHERE `active`='1' AND `category_parent` = '0' ORDER BY `id`"; $category_list = $wpdb->get_results($category_sql, ARRAY_A); } if ($category_list != null) { foreach ($category_list as $category) { display_category_row($category, $level); display_categories($category['id'], $level + 1); } } }
function display_categories($group_id, $id = null, $level = 0) { global $wpdb, $category_data; if (is_numeric($id)) { $category_sql = "SELECT * FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `group_id` IN ('{$group_id}') AND `active`='1' AND `category_parent` = '" . $id . "' ORDER BY `id`"; $category_list = $wpdb->get_results($category_sql, ARRAY_A); } else { $category_sql = "SELECT * FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `group_id` IN ('{$group_id}') AND `active`='1' AND `category_parent` = '0' ORDER BY `id`"; $category_list = $wpdb->get_results($category_sql, ARRAY_A); } if ($category_list != null) { foreach ($category_list as $category) { display_category_row($category, $level); display_categories($group_id, $category['id'], $level + 1); } } }