<?PHP
$query = "SELECT * FROM `players`";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result) {
$oldName = $row['name'];
$playerId = $row['id'];
$newName = ucwords(strtolower($oldName));
$updateQuery = "UPDATE `players` SET `name` = '$newName' WHERE `id` = '$playerId'";
$updateResult = mysql_query($updateQuery);
}
?>