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 );}?>

Dan Becker's Game Page

Delete Tournament Plays

Purpose: Select records and delete plays in the tournament database.


Select via game date and selection boxes:
Filter records here:
\n";if ( isset( $command ) ) { // echo "DEBUG: Command is set to \"$command\".
\n"; if (0 == strcmp( $command, "filter" )) { filterValues(); // echo "

DEBUG: fromDate=$fromDate, toDate=$toDate.

\n"; $playIDs = filterPlays( $fromDate, $toDate ); } else if (0 == strcmp( $command, "delete" )) { // echo "DEBUG: command=delete.
\n"; if ( isset( $gameIDs ) ) { // echo "

DEBUG: count(gameIDs)=" . count( $gameIDs ) . "

\n"; deleteRecords( $gameIDs ); unset( $gameIDs ); } } unset( $command );} // issetfilterForm();selectForm( $playIDs, "delete", "Delete" );?>
User menu |Admin menu