// CHECK FOR CORRUPTED TABLES

// get names of all tables

$query = "SHOW TABLES";

$result = mysql_query($query) or trigger_error("\nMySQL said:
".mysql_error(), E_USER_ERROR);

$tableNames = array();

while($row = mysql_fetch_array($result,MYSQL_NUM)) {

    $tableNames[] = $row[0];

}

// check all tables

$query = "CHECK TABLE ".implode(',',$tableNames);

$result = mysql_query($query) or trigger_error("\nMySQL said:
".mysql_error(), E_USER_ERROR);

$messageArray = array();

// if any tables are not 'OK', add to an array.

while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {

    if($row['Msg_text'] != 'OK') {

        $messageArray[] = $row;

    }

}

if(count($messageArray) > 0) {

    $message = "MySQL Status Information :

Table\t\tOp\t\tMsg_type\t\tMsg_text

";

    foreach($messageArray as $value) {

        $message .= implode("\t",$value)."\n";

    }

    mail('techsupport@resultsnow.com',"MySQL Table
Maintainence",$message);

}