dip / testsp1.php

<?

include("minc.php");

//--------------------------Списки записей в портфеле
$sql='delete from T_CONTEXTQ';
mysql_query($sql);
echo mysql_error();

//--------------------------Подзаписи записи в портфеле
$sql= "INSERT INTO T_CONTEXTQ ".
      "select count(*) AS CONLINK,D.DATEIN,D.RID,D.AID,D.OWNRID,D.TEXTF,D.DATEF,D.INTF,D.ATYPE ".
      " from  TWORDLINK B, T_RECQUERY D ".
      " WHERE  ".
      " D.RID=B.RID  ".
      " GROUP BY D.DATEIN,D.RID,D.AID,D.OWNRID,D.TEXTF,D.DATEF,D.INTF,D.ATYPE ".
      " HAVING COUNT(*)>1 order by CONLINK DESC ";

mysql_query($sql);
echo mysql_error();




?>