#!/usr/bin/php 0) { // Delete $db_handle = mysql_connect($db_host, $db_user, $db_pass); $db_found = mysql_select_db($db, $db_handle); $sql = "DELETE FROM $table WHERE comment_approved = '$approved_value'"; // Execute //echo " * Deleting $comment_count comments from table '$table'\n"; //$result = mysql_query($sql); mysql_close($db_handle); } else { echo " * Nothing to do\n"; } echo "\n"; } else { // DB Error print "Database not found!\n"; mysql_close($db_handle); } } // Call function // --------------------------------------------------------------------------- delete_spam_comments('wordpress_site_1', 'comments'); delete_spam_comments('wordpress_site_2', 'yx6vet3e_comments'); delete_spam_comments('wordpress_site_3', 'hidden_comments'); ?>