Update Game Names

Purpose: Globally change Game name and id from one to another.

This is useful over generic SQL commands because you can seethe game names and ids before you change them.
\n"; $results = sqlQuery( $sql, false ); $toID = mysql_insert_id(); } if ( isset( $toID ) ) { $sql = "UPDATE $playsTable SET gameid=$toID WHERE "; for ( $i = 0; $i < $numFromNames; $i++ ) { // echo "DEBUG: Changing game id=$fromID to id=$toID.
\n"; // DEBUG if ( $i > 0 ) $sql .= " || "; $fromID = $fromNames[ $i ]; $sql .= "( gameid=$fromID )"; } // for // echo "DEBUG: sql=$sql
\n"; $results = sqlQuery( $sql, false ); $numRows = mysql_affected_rows(); if ( $numRows == 1 ) echo "$numRows row was updated in $playsTable.
\n"; else echo "$numRows rows were updated in $playsTable.
\n"; $numRows = mysql_affected_rows(); } if ( isset( $deleteFromIDs ) ) { $sql = "DELETE FROM $gameNamesTable WHERE "; for ( $i = 0; $i < $numFromNames; $i++ ) { // echo "DEBUG: Changing game id=$fromID to id=$toID.
\n"; // DEBUG if ( $i > 0 ) $sql .= " || "; $fromID = $fromNames[ $i ]; $sql .= "( gameid=$fromID )"; } // for // echo "DEBUG: sql=$sql
\n"; $results = sqlQuery( $sql, false ); $numRows = mysql_affected_rows(); if ( $numRows == 1 ) echo "$numRows row was deleted from $gameNamesTable.
\n"; else echo "$numRows rows were deleted from $gameNamesTable.
\n"; }} // if ( isset( $fromNames ) ) {// Make an id frequency array. key=id, value=freqency$frequency = array();$sql = "SELECT gameid, COUNT( * ) AS 'freq' FROM $playsTable GROUP BY gameid";$sqlResults = sqlQuery( $sql, false );// Turn result into array. Use MYSQL_ASSOC, MYSQL_NUM, or MYSQL_BOTH to select keying.while ( $data = mysql_fetch_array( $sqlResults, MYSQL_ASSOC )) { $id = $data[ "gameid" ]; $count = $data[ "freq" ]; $frequency[ $id ] = $count;} // while// Display game names.$sql = "SELECT gameid, name FROM $gameNamesTable ORDER BY name";$sqlResults = sqlQuery( $sql, false );$numRows = mysql_num_rows( $sqlResults );echo "

Change Game Names