查询未将数据插入表中，但它返回成功状态 - Query not inserting data into table however It returns success status

Query not inserting data into table however It returns success status

我正在尝试使用以下代码在表中插入数据。

$query2 = "insert into  aerion. prosp_contact(prosp_consult_id,contact_id,prosp_contact_type,summary) VALUES(".$pid.",'".$id1."','".$cnt_typ[$i]."','".$cnt_smry[$i]."') ";
$res2 = mysql_query($query2) or die(mysql_error()) ;

查询返回成功状态，但未插入表的数据。任何帮助将不胜感激。

缺少一个 qutoation 用法

$query2 = "INSERT INTO  aerion.
   prosp_contact(prosp_consult_id,contact_id,prosp_contact_type,summary)      
  VALUES('".$pid."','".$id1."','".$cnt_typ[$i]."','".$cnt_smry[$i]."') ";
 $res2 = mysql_query($query2) or die(mysql_error()) ;

很抱歉给您带来麻烦，

    I found solution. There was error in my logic. row was getting deleted immediately after it was added.

谢谢你的时间。