Dan Becker's Game Page

Update Table Field Data

Purpose: Change data in a field to something else.
Example: Change all Plays.game values from "Hook or Crook" to "Adel Verplichtet".

\n"; echo "Tables in \"$dbname\"\n"; echo "\n\n"; if ( $tablelist = mysql_list_tables( $dbname )) { echo " \n"; for ($i = 0; $i < mysql_num_rows( $tablelist ); $i++) { $tableName = mysql_tablename( $tablelist, $i ); if ( 0 == strcmp( $tableName, $selectedTable ) ) { echo " $tableName\n"; } else { echo " $tableName\n"; } } echo " \n\n\n"; echo "\n"; echo "Number of tables: " . mysql_num_rows( $tablelist ) . "\n"; echo "\n"; } else { echo "No tables in database.\n"; } echo "\n";} // displayTableTable function displayTableFields( $dbname, $tableName, $rowCount=4 ) { global $selectedField; echo "\n"; echo "\n"; echo "\n\n\n"; echo "\n"; } else { echo "No fields in table \"$tableName\".\n"; } echo "

Fields for \"$tableName\"
\n"; if ( $fieldlist = mysql_list_fields( $dbname, $tableName )) { echo " \n"; for ($i = 0; $i < mysql_num_fields( $fieldlist ); $i++) { $fieldName = mysql_field_name( $fieldlist, $i ); if ( 0 == strcmp( $fieldName, $selectedField ) ) { echo " $fieldName\n"; } else { echo " $fieldName\n"; } } echo " \n
\n"; echo "Number of fields: " . mysql_num_fields( $fieldlist ) . "\n"; echo "

\n";} // displayTableFields function displayValues( $dbname, $tableName, $fieldName, $fromValue, $toValue ) { global $selectedField; echo "\n"; echo "\n"; echo "\n\n\n\n

Values
From	\n"; echo "\n"; echo "
To	\n"; echo "\n"; echo "

\n";} // displayValues function displayRows( $dbname, $tableName, $selectedField, $matchValue ) { $sql = "SELECT * FROM $tableName WHERE ( $selectedField LIKE '$matchValue' ) ORDER BY $selectedField ASC"; $sqlResults = sqlQuery( $sql, false ); $rowCount = 0; if ( mysql_num_rows( $sqlResults ) > 0 ) { // use mysql_fetch_row for enumerated, mysql_fetch_array for associative while ( $row = mysql_fetch_row( $sqlResults )) { if ( $rowCount == 0 ) { echo "\n"; echo "\n"; if ( $fieldlist = mysql_list_fields( $dbname, $tableName )) { echo "\n"; echo "\n"; for ($i = 0; $i < mysql_num_fields( $fieldlist ); $i++) { $fieldName = mysql_field_name( $fieldlist, $i ); if ( 0 == strcmp( $fieldName, $selectedField ) ) { echo "\n"; } else { echo "\n"; } } echo "\n"; } // fields } echo ""; echo ""; for ( $i = 0; $i < sizeof( $row ); $i++ ) { echo ""; } // for echo "\n"; $rowCount++; } // while echo "

Matching Data
row	$fieldName like '$matchValue'	$fieldName
$rowCount	" . $row[ $i ] . "

\n"; } // if echo "There are " . mysql_num_rows( $sqlResults ) . " rows with field $selectedField matching \"$matchValue\".
\n"; } // displayRows function updateRows( $dbname, $tableName, $selectedField, $fromValue, $toValue ) { $sql = "UPDATE $tableName SET $selectedField = '$toValue' WHERE ( $selectedField LIKE '$fromValue' )"; // echo "DEBUG: sql=$sql\n"; // DEBUG $sqlResults = sqlQuery( $sql, false ); echo "There were " . mysql_affected_rows( $sqlResults ) . " rows with field $selectedField matching \"$fromValue\".
\n"; } // updateRows echo "