<?
if(!$pidx) $pidx=0;
$i=0;
if($pidx!=0){
while(1){
$query="select * from radar.PROJECT where P_IDX=".$pidx."";
$res = mysql_query($query, $Conn) or
die('SQL:-1 ' . $query . '<br> ㅁㄴㅇ<br>' . mysql_errno() . ': ' . mysql_error());
$btData = mysql_fetch_array($res);
$stack[$i]['P_PARENT']=$btData['P_PARENT'];
$stack[$i]['P_NAME']=$btData['P_NAME'];
$stack[$i]['P_IDX']=$btData['P_IDX'];
$pidx=$btData['P_PARENT'];
if(!$btData['P_PARENT']) break;
$i++;
}
//print_r($stack);
//echo $i;
}
?>
<!-- 프로젝트 선택 시작 -->
<?
echo "<a href=channel.php?pidx=0>ROOT</a> > ";
for($i;$stack[$i];$i--){
echo "<a href='channel.php?pidx=".$stack[$i]['P_IDX']."'>[".$stack[$i]['P_NAME']."]</a> > ";
//echo $stack[$i]['P_IDX'].",";
//echo $stack[$i]['P_PARENT'].",";
//echo $stack[$i]['P_NAME'].",";
$pidx=$stack[$i]['P_IDX'];
$select_name=$stack[$i]['P_NAME'];
}
$query="select count(*) from radar.PROJECT where P_PARENT=".$pidx;
$res = mysql_query($query, $Conn) or
die('SQL:0: ' . $query . '<br> ㅁㄴㅇ<br>' . mysql_errno() . ': ' . mysql_error());
$btData = mysql_fetch_array($res);
?>
<? if($btData[0]>0){ ?>
<select name="1" onchange="window.open(value,'_self');" size=1>
<option >선택하세요.</option>
<?
$query="select * from radar.PROJECT where P_PARENT=".$pidx;
$res = mysql_query($query, $Conn) or
die('SQL:0: ' . $query . '<br> ㅁㄴㅇ<br>' . mysql_errno() . ': ' . mysql_error());
for($i=1;$btData = mysql_fetch_array($res);$i++)
{
?>
<option value="channel.php?pidx=<?=$btData[P_IDX]?>" <?=selected($btData[P_IDX],$pidx)?>>[<?=$btData[P_NAME]?>]</option>
<?}?>
</select>
<? } ?>
스텍같은 기능으로 마지막에 넣은게 첨나오게...
중간부터 시작해서 4>3>2>1>0 이렇게 집어 넣고
0>1>2>3>4 이렇게 빼서...
4아래에 또 뭐 있나 검사하면 끝!
아..생각보다 간단한건데.. ㅠㅠ 켕..