selectLinkAll($range1);$arrayResultLink = ""; $arraySort = ""; while ($rowLink = mysql_fetch_array($resultLink, MYSQL_NUM)) {//while() $arrayResultLink[] = $rowLink; }//while() if (@$_REQUEST["optionCategory"] == "ordCategory") {//($op == "ordCategory") $arrayTMP = $arrayResultLink; $i = 0; foreach($arrayResultLink as $arl) {//foreach() $resultCategory = $linkex->selectCategory($arl[4]); $rowCategory = mysql_fetch_array($resultCategory, MYSQL_NUM); $arrayTMP[$i][4] = $rowCategory[0]; $i++; }//foreach() $arraySort = sortArray($arrayTMP,4); }//($op == "ordCategory") elseif (@$_REQUEST["optionCategory"] == "ordURL") {//($op == "ordURL") $arraySort = sortArray($arrayResultLink,2); }//($op == "ordURL") elseif (@$_REQUEST["optionCategory"] == "ordDescription") {//($op == "ordDescription") $arraySort = sortArray($arrayResultLink,3); }//($op == "ordDescription") echo "
"; search(0); echo menuCreator(1); echo ""; echo "
"; if (empty($arraySort)) {//if for ($i = 0; $i < count($arrayResultLink); $i++) {//for() $resultCategory = $linkex->selectCategory($arrayResultLink[$i][4]); $rowCategory = mysql_fetch_array($resultCategory, MYSQL_NUM); echo ""; }//for() }//if else {//else foreach ($arraySort as $as) {//foreach() $resultCategory = $linkex->selectCategory($arrayResultLink[$as][4]); $rowCategory = mysql_fetch_array($resultCategory, MYSQL_NUM); echo ""; }//foreach() }//else echo "

View Categories
Category	URL	Description
".$rowCategory[0]."	".$arrayResultLink[$i][2]."	".$arrayResultLink[$i][3]."
".$rowCategory[0]."	".$arrayResultLink[$as][2]."	".$arrayResultLink[$as][3]."

"; $linkex->disconnect(); menu(); footerHtml(); function sortArray($array, $id) {//sortArray() $newArray = ""; $j = 0; for ($i = 0;$i < count($array); $i++) {//i if (@array_key_exists($array[$i][$id], $newArray)) {//if () $array[$i][$id] = $array[$i][$id]."|".$j; $j++; }//if () $newArray[$array[$i][$id]] = $i; }//i ksort($newArray); reset($newArray); return $newArray; }//sortArray() ?>