PHP Code:

<?php
$CID = $_GET['CID'];
$con = mysql_connect("mysqlhost.netfirms.com:3306","uxxxxxxx","abxxx");
if (!$con)
 {
  die('Could not connect: ' . mysql_error());
 }
mysql_select_db("database", $con);
mysql_query("DELETE FROM mypersonalcontacts WHERE CID='$CID'");
echo "Record No.$CID was DELETED";
mysql_close();
?>

Try this,

PHP Code:

<?php
$CID = $_GET['CID'];
if($_GET['confirmed'] === 'yes'){
$con = mysql_connect("mysqlhost.netfirms.com:3306","uxxxxxxx","abxxx");
if (!$con)
 {
  die('Could not connect: ' . mysql_error());
 }
mysql_select_db("database", $con);
mysql_query("DELETE FROM mypersonalcontacts WHERE CID='$CID'");
echo "Record No.$CID was DELETED";
mysql_close();
} else {
?>
<a href="?CID=<?php echo $CID;?>&confirmed=yes">Are you sure?</a>
<?php
}
?>

It makes the user confirm they want to delete it with an extra link.

Thank you very much. It's exactly what i wanted.