<?php show_source(end(explode('/',$_SERVER['PHP_SELF']))); echo "<hr>"; ?>
<?php

$handle = mysql_connect('localhost', 'tobyjoe', 'php');

if($handle == false){
    die("Could not connect to MySQL. Exiting.\r\n");
}

$db = mysql_select_db('test');

if($db == false){
    die("Could not select MySQL DB. Exiting.\r\n");
}

$query = 'UPDATE user SET user_name="tobyjoe" WHERE user_name="toby"';

$result = mysql_query($query, $handle);

if($result == false){
    die("Error with query.\r\n");
}

$num = mysql_affected_rows($handle);

echo "Affected rows: $num.\r\n";

mysql_close($handle);

?>