Permalink
Browse files

exclude self links

  • Loading branch information...
1 parent f7c87a7 commit 3262090ef3f8540e0294cd4c823fcec062f110d2 @computermacgyver committed Oct 18, 2012
Showing with 1 addition and 1 deletion.
  1. +1 −1 listNodes_graphml.php
View
@@ -45,7 +45,7 @@
//$strSQL="SELECT tblPages.strCleanURL as fkParentID, t.strCleanURL as fkChildID, SUM(iNumberTimes) as iNumberTimes FROM (tblLinks INNER JOIN tblPages as t ON tblLinks.fkChildID=t.iPageID) INNER JOIN tblPages ON tblLinks.fkParentID=tblPages.iPageID WHERE tblPages.bolCentral=1 AND t.bolCentral=1 AND NOT tblPages.bolExclude AND NOT t.bolExclude AND tblPages.strDomain='$strDomain' AND t.strDomain='$strDomain'";
$nodeList=implode(",",$arrNodes);
-$strSQL="SELECT fkParentID, fkChildID, iNumberTimes FROM tblLinks WHERE fkParentID IN ($nodeList) AND fkChildID IN ($nodeList)";
+$strSQL="SELECT fkParentID, fkChildID, iNumberTimes FROM tblLinks WHERE fkParentID IN ($nodeList) AND fkChildID IN ($nodeList) AND fkParentID<>fkChildID";
$result = mysql_query($strSQL);

0 comments on commit 3262090

Please sign in to comment.