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
?>