// YOUR MSSQL 7.0 SERVER PARAMETERS
$hostname = "12.1.244.139";
$username = "phpuser";
$password = "phpuser";
// YOUR MSSQL 7.0 DATABASE
$dbname = "contacts";
// CONNECT TO THE MSSQL 7.0 DATABASE
$connection = mssql_connect($hostname,$username,$password);
mssql_select_db("$dbname");
if ($inup == "i") {
$sql_query = "INSERT INTO tbl_contacts (LastName, FirstName, Address1, Address2, City, State, Zip, Notes) VALUES ('$LastName', '$FirstName', '$Address1', '$Address2', '$City', '$State', '$Zip', '$Notes')";
echo "Your entry was added succesfully.
";
}
else {
$sql_query = "UPDATE tbl_contacts SET LastName = '$LastName', FirstName = '$FirstName', Address1 = '$Address1', Address2 = '$Address2', City = '$City', State = '$State', Zip = '$Zip', Notes = '$Notes' WHERE LastName = '$LastName'";
echo "Your entry was updated succesfully.
";
}
$query_result = mssql_query($sql_query);
mssql_close($connection);
?>
= $FirstName ?>
= $LastName ?>
= $Address1 ?>
= $Address2 ?>
= $City ?>
= $State ?>
= $Zip ?>
= $Notes ?>
= $inup ?>