Use this to create what you are after....
<?php
if($delete)
{
//delete the records
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "database_name";
$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("$dbname",$db);
mysql_query("DELETE FROM $table WHERE whatever='$input1'");
print ("Records have been deleted");
}
if($update)
{
//update the records
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "database_name";
$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("$dbname",$db);
mysql_query("UPDATE $table SET field1='$input1',field2='$input2' WHERE whatever='$whatever'");
}
?>
<body>
<form action="this_page.php3">
<input type="text" name="input1">
<input type="text" name="input2">
<input type="submit" name="delete" value="delete">
<input type="submit" name="update" value="update">
</form>
</body>
hth
scott d~
