Advertisement
terorama

dip / testsp1.php

Aug 21st, 2012
38
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.65 KB | None | 0 0
  1.  
  2.  
  3. <?
  4.  
  5. include("minc.php");
  6.  
  7. //--------------------------Списки записей в портфеле
  8. $sql='delete from T_CONTEXTQ';
  9. mysql_query($sql);
  10. echo mysql_error();
  11.  
  12. //--------------------------Подзаписи записи в портфеле
  13. $sql= "INSERT INTO T_CONTEXTQ ".
  14.       "select count(*) AS CONLINK,D.DATEIN,D.RID,D.AID,D.OWNRID,D.TEXTF,D.DATEF,D.INTF,D.ATYPE ".
  15.       " from  TWORDLINK B, T_RECQUERY D ".
  16.       " WHERE  ".
  17.       " D.RID=B.RID  ".
  18.       " GROUP BY D.DATEIN,D.RID,D.AID,D.OWNRID,D.TEXTF,D.DATEF,D.INTF,D.ATYPE ".
  19.       " HAVING COUNT(*)>1 order by CONLINK DESC ";
  20.      
  21. mysql_query($sql);
  22. echo mysql_error();
  23.  
  24.  
  25.  
  26.  
  27. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement