DEBUG: You asked to delete " . count( $playIDs ) . " records.
"; $set = "( "; for ( $i = 0; $i < count( $playIDs ); $i++ ) { if ( $i > 0 ) $set .= ", "; $set .= $playIDs[ $i ]; } $set .= " )"; // Multi table delete supported in MySQL 4.0 and greater // $sql = "DELETE TPlays, TComments, TScores FROM TPlays, TComments, TScores // WHERE ( TPlays.id IN $set AND TComments.idPlays = TPlays.id AND TScores.playid = TPlays.id )"; $sql = "DELETE FROM TComments WHERE ( TComments.idPlays IN $set )"; $sqlResults = sqlQuery( $sql, $verbose ); $sql = "DELETE FROM TScores WHERE ( TScores.idPlays IN $set )"; $sqlResults = sqlQuery( $sql, $verbose ); $sql = "DELETE FROM TPlays WHERE ( TPlays.id IN $set )"; $sqlResults = sqlQuery( $sql, $verbose );}?>Purpose: Select records and delete plays in the tournament database.
DEBUG: fromDate=$fromDate, toDate=$toDate.
\n"; $playIDs = filterPlays( $fromDate, $toDate ); } else if (0 == strcmp( $command, "delete" )) { // echo "DEBUG: command=delete.DEBUG: count(gameIDs)=" . count( $gameIDs ) . "
\n"; deleteRecords( $gameIDs ); unset( $gameIDs ); } } unset( $command );} // issetfilterForm();selectForm( $playIDs, "delete", "Delete" );?>