Category Cleaner"; if ($_POST[submit_cleancat]) { // show results $num_per_cat=$_POST[num_per_cat]; echo "Showing entries with less than $num_per_cat"; $myquery = " SELECT * FROM wp_term_taxonomy, wp_terms WHERE wp_term_taxonomy.count<=$num_per_cat AND wp_terms.term_id=wp_term_taxonomy.term_id "; echo "
$myquery
"; $result = mysql_query($myquery); while ($row = mysql_fetch_assoc($result)) { echo "
"; echo "Term: " . $row['term_id'] . "
" ; echo "Name: " . $row['name'] . "
"; echo "Count: " . $row['count'] . "
"; echo "
"; wp_delete_category($row['term_id']); echo "Deleted $row[name]
"; echo "
"; } } else { // display form ?>
Min # of entries per cat (enter 0 to delete unused cats):