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;
Exemple #2
0
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>&nbsp;".$predai_natatak."&nbsp;".$r[1]."<br>";
        $arrXXX[] = $predai_natatak . "|" . $r[0];
        $arrYYY[] = $r[0];
        $broia4++;
        getTree2_1($r[0], $predai_natatak, $arrXXX, $arrYYY);
    }
}