update & delete from mysql

[bike5]

How would I update colums in a row and delete whole rows.

$DBName = "*";
$TableName = "*";
$Link = mysql_connect ($Host, $User, $Password);

I will have a form with 2 text inputs:
user_name and user_newname
and a check box, value ON will be to delete the row that the user_name is on.

If you could just point me at the code that checks for the name in the table and then replaces it and the coding for deletion. I should be able to fill in the rest.

Thanks a lot in advance.

[[deleted]]

you can do something like this:

if($_POST['checkbox' == "ON") {
$query = "DELETE FROM $TableName WHERE user_name = '$user_name'";
} else {
$query = "UPDATE $TableName SET user_name = '$user_newname' WHERE user_name = '$user_name'";
}

mysql_query($query);

Hope that helps..
Matt Wade
http://codewalkers.com/