여러 테이블글중에 최신글로 정렬해서 10개 뽑기 등의 경우를 위해 쓴다.

핵심함수는

array_multisort($aaa,SORT_DESC,$arr_list);

아래 소스를 참고 하시길..



++++++++++++++++++++++++++++++++++++++++++++++++++++++++





$arr_tbn = array($tbn1,$tbn2,$tbn3,$tbn4);

	

$j=0;

for($i=0;$i<count($arr_tbn);$i++){

	

	if($arr_tbn[$i] == ""){

		break;

	}

	

	

	$sql = "select * from $arr_tbn[$i] order by regdate desc limit 0,$rnum ";

	$result = mysql_query($sql,$dbconn);

		

	while( $row = mysql_fetch_array($result) ){

		$subject = $row["subject"];

		$cn = $row["cateNum"];

		$num = $row["num"];

		$regdate = $row["regdate"];

		

		$arr_list[$j][subject] = StringCut( $subject, 25, $EndMark='...' );

		$arr_list[$j][tbn] = $arr_tbn[$i];

		$arr_list[$j][cn] = $cn;

		$arr_list[$j][num] = $num;

		$arr_list[$j][regdate] = $regdate;

		$arr_list[$j][dir] = $dir;

		

		

		$j++;

	}

	

	mysql_free_result($result);

	$j++;

}



foreach ($arr_list as $key=>$value) {

	$aaa[$key] = $value[regdate];

}



array_multisort($aaa,SORT_DESC,$arr_list);		

reset($arr_list);



$k=0;

foreach ($arr_list as $key=>$value) {

	if($k < $rnum){

		echo chr(7)." <a href='/$value[dir]/view.php?tbn=$value[tbn]&cn=$value[cn]&num=$value[num]'>".$value[subject]."</a>";

		echo "<br>";

	}else{

		break;

	}

	$k++;

}

날짜: 2005-07-28 16:17:30, 조회수: 2472