if ($row2 = mysql_fetch_array($rs2)) { $p_name = $row2['p_name']; $p_desc = $row2['p_desc']; $p_phase = htmlspecialchars($row2['p_phase']); $p_status = htmlspecialchars($row2['p_status']); $p_leader = htmlspecialchars($row2['u_name']); $p_date = htmlspecialchars($row2['d1']); } $query = "select * from requirements where r_p_id=" . $p_id . " and r_parent_id=0 order by r_pos asc"; $rs = mysql_query($query) or die(mysql_error()); $cnt45 = 0; while ($row = mysql_fetch_array($rs)) { $cnt45++; $arr45[] = $cnt45 . "|" . $row['r_id']; $arr45_1[] = $row['r_id']; getTree2_1($row['r_id'], $cnt45, $arr45, $arr45_1); } ?> <?php //sortable columns if ($order == "") { $order = "r_change_date desc"; } //search $filter5 = escapeChars(stripslashes($filter5)); /* if ($filter1!="") $search.=" and r.r_u_id=".$filter1; if ($filter2!="") $search.=" and r.r_state=".$filter2; if ($filter4!="") $search.=" and r.r_priority=".$filter4;
function getTree2_1($parentID, $cifri_otpred = "", &$arrXXX, &$arrYYY) { //echo $parentID."<br>"; $q = "select r_id, r_name from requirements where r_parent_id='" . $parentID . "' order by r_pos asc"; $rs = mysql_query($q) or die("..."); $broia4 = 1; while ($r = mysql_fetch_array($rs)) { $predai_natatak = $cifri_otpred . "." . $broia4; //echo ""; //echo "<br> ".$predai_natatak." ".$r[1]."<br>"; $arrXXX[] = $predai_natatak . "|" . $r[0]; $arrYYY[] = $r[0]; $broia4++; getTree2_1($r[0], $predai_natatak, $arrXXX, $arrYYY); } }