Mysql entry

$link =  mysql_connect($database_server,$database_user,$database_password) or die (mysql_error()); 
 $db = mysql_select_db($dbase, $link);
 $r = mysql_query("SELECT personID FROM modx_web_user_1_data WHERE txn_id='".$_POST["txn_id"]."'");
  list($duplicate) = mysql_fetch_row($r);
  mysql_free_result($r);
  if ($duplicate) die ("I feel like I met you before ..."); 

$query = "INSERT INTO modx_web_user_1_data(status, txn_id) VALUES ('".$payment_status."', '".$_POST["txn_id"]."') WHERE personID = ".$item_number." ON DUPLICATE KEY UPDATE column = column + 1";
$result = mysql_query($query);