정렬에사용되는 함수좀부탁드립니다 정보
정렬에사용되는 함수좀부탁드립니다본문
게시판1 과 게시판2에서 데이터를가져와 게시판3에 뿌려주는데
각 데이터의 일자가 wr_6 에 datatime형식으로저장되있습니다.
wr_6 의 가장가까운 시간 순서대로 정렬하려면 어디를추가해야되는지 부탁드립니다.
=======================================================================================
<?
include_once("_common.php");
$sql = "SELECT * FROM g4_write_a10 where deleted = '0000-00-00 00:00:00'";
$res = mysql_query($sql);
while($val = mysql_fetch_assoc($res)){
$val['sca'] = $val['bo_table'];
unset($bsql); unset($bres); unset($ca_name);
$bsql = "SELECT bn_alt FROM yc4_banner WHERE bn_id = '$val[ca_name]'";
$bres = mysql_fetch_row(mysql_query($bsql));
$ca_name = iconv("euc-kr","utf-8",$bres[0]);
//$val['wr_id'] = "a10_".$val['wr_id'];
$val['group_id'] = "a10_".$val['group_id'];
$val['wr_4'] = iconv("euc-kr","utf-8",$val['wr_4']);
$val['wr_5'] = iconv("euc-kr","utf-8",$val['wr_5']);
$val['wr_7'] = iconv("euc-kr","utf-8",$val['wr_7']);
$val['ca_name'] = "<img src='/data/banner/$val[ca_name]' border='0' align='absmiddle'> <font color='1a8502'>$ca_name <font color='494646'>($val[wr_7])";
$arr[] = $val;
}
$sql = "SELECT * FROM g4_write_a20 where deleted = '0000-00-00 00:00:00'";
$res = mysql_query($sql);
while($val = mysql_fetch_assoc($res)){
$val['sca'] = $val['bo_table'];
unset($bsql); unset($bres); unset($ca_name);
$bsql = "SELECT bn_alt FROM yc4_banner WHERE bn_id = '$val[ca_name]'";
$bres = mysql_fetch_row(mysql_query($bsql));
$ca_name = iconv("euc-kr","utf-8",$bres[0]);
//$val['wr_id'] = "a20_".$val['wr_id'];
$val['group_id'] = "a20_".$val['group_id'];
$val['wr_4'] = iconv("euc-kr","utf-8",$val['wr_4']);
$val['wr_5'] = iconv("euc-kr","utf-8",$val['wr_5']);
$val['wr_7'] = iconv("euc-kr","utf-8",$val['wr_7']);
$val['ca_name'] = "<img src='/data/banner/$val[ca_name]' border='0' align='absmiddle'> <font color='c5d611'>$ca_name <font color='494646'>($val[wr_7])";
$arr[] = $val;
}
echo json_encode($arr);
?>
각 데이터의 일자가 wr_6 에 datatime형식으로저장되있습니다.
wr_6 의 가장가까운 시간 순서대로 정렬하려면 어디를추가해야되는지 부탁드립니다.
=======================================================================================
<?
include_once("_common.php");
$sql = "SELECT * FROM g4_write_a10 where deleted = '0000-00-00 00:00:00'";
$res = mysql_query($sql);
while($val = mysql_fetch_assoc($res)){
$val['sca'] = $val['bo_table'];
unset($bsql); unset($bres); unset($ca_name);
$bsql = "SELECT bn_alt FROM yc4_banner WHERE bn_id = '$val[ca_name]'";
$bres = mysql_fetch_row(mysql_query($bsql));
$ca_name = iconv("euc-kr","utf-8",$bres[0]);
//$val['wr_id'] = "a10_".$val['wr_id'];
$val['group_id'] = "a10_".$val['group_id'];
$val['wr_4'] = iconv("euc-kr","utf-8",$val['wr_4']);
$val['wr_5'] = iconv("euc-kr","utf-8",$val['wr_5']);
$val['wr_7'] = iconv("euc-kr","utf-8",$val['wr_7']);
$val['ca_name'] = "<img src='/data/banner/$val[ca_name]' border='0' align='absmiddle'> <font color='1a8502'>$ca_name <font color='494646'>($val[wr_7])";
$arr[] = $val;
}
$sql = "SELECT * FROM g4_write_a20 where deleted = '0000-00-00 00:00:00'";
$res = mysql_query($sql);
while($val = mysql_fetch_assoc($res)){
$val['sca'] = $val['bo_table'];
unset($bsql); unset($bres); unset($ca_name);
$bsql = "SELECT bn_alt FROM yc4_banner WHERE bn_id = '$val[ca_name]'";
$bres = mysql_fetch_row(mysql_query($bsql));
$ca_name = iconv("euc-kr","utf-8",$bres[0]);
//$val['wr_id'] = "a20_".$val['wr_id'];
$val['group_id'] = "a20_".$val['group_id'];
$val['wr_4'] = iconv("euc-kr","utf-8",$val['wr_4']);
$val['wr_5'] = iconv("euc-kr","utf-8",$val['wr_5']);
$val['wr_7'] = iconv("euc-kr","utf-8",$val['wr_7']);
$val['ca_name'] = "<img src='/data/banner/$val[ca_name]' border='0' align='absmiddle'> <font color='c5d611'>$ca_name <font color='494646'>($val[wr_7])";
$arr[] = $val;
}
echo json_encode($arr);
?>
댓글 전체
<?
include_once("_common.php");
$sql = "SELECT * FROM g4_write_a10 where deleted = '0000-00-00 00:00:00'";
$res = mysql_query($sql);
$sort_arr = array();//추가
while($val = mysql_fetch_assoc($res)){
$val['sca'] = $val['bo_table'];
unset($bsql); unset($bres); unset($ca_name);
$bsql = "SELECT bn_alt FROM yc4_banner WHERE bn_id = '$val[ca_name]'";
$bres = mysql_fetch_row(mysql_query($bsql));
$ca_name = iconv("euc-kr","utf-8",$bres[0]);
//$val['wr_id'] = "a10_".$val['wr_id'];
$val['group_id'] = "a10_".$val['group_id'];
$val['wr_4'] = iconv("euc-kr","utf-8",$val['wr_4']);
$val['wr_5'] = iconv("euc-kr","utf-8",$val['wr_5']);
$val['wr_7'] = iconv("euc-kr","utf-8",$val['wr_7']);
$val['ca_name'] = "<img src='/data/banner/$val[ca_name]' border='0' align='absmiddle'> <font color='1a8502'>$ca_name <font color='494646'>($val[wr_7])";
$arr[] = $val;
$sort_arr[] = strtotime($val[wr_6]) ;//2004-02-01 형식인경우 //time 으로 저장하경우 strtotime 제거
}
$sql = "SELECT * FROM g4_write_a20 where deleted = '0000-00-00 00:00:00'";
$res = mysql_query($sql);
while($val = mysql_fetch_assoc($res)){
$val['sca'] = $val['bo_table'];
unset($bsql); unset($bres); unset($ca_name);
$bsql = "SELECT bn_alt FROM yc4_banner WHERE bn_id = '$val[ca_name]'";
$bres = mysql_fetch_row(mysql_query($bsql));
$ca_name = iconv("euc-kr","utf-8",$bres[0]);
//$val['wr_id'] = "a20_".$val['wr_id'];
$val['group_id'] = "a20_".$val['group_id'];
$val['wr_4'] = iconv("euc-kr","utf-8",$val['wr_4']);
$val['wr_5'] = iconv("euc-kr","utf-8",$val['wr_5']);
$val['wr_7'] = iconv("euc-kr","utf-8",$val['wr_7']);
$val['ca_name'] = "<img src='/data/banner/$val[ca_name]' border='0' align='absmiddle'> <font color='c5d611'>$ca_name <font color='494646'>($val[wr_7])";
$arr[] = $val;
$sort_arr[] = strtotime($val[wr_6]) ;//2004-02-01 형식인경우 //time 으로 저장하경우 strtotime 제거
}
/* 이부분 추가*/
$temp_arr = array(); //추가
asort($sort_arr);
foreach ($sort_arr as $key => $val) {
$temp_arr[] = $arr[$key];
}
$arr = $temp_arr;
//추가 완료
echo json_encode($arr);
?>
처럼 하면 되지 않을까요
include_once("_common.php");
$sql = "SELECT * FROM g4_write_a10 where deleted = '0000-00-00 00:00:00'";
$res = mysql_query($sql);
$sort_arr = array();//추가
while($val = mysql_fetch_assoc($res)){
$val['sca'] = $val['bo_table'];
unset($bsql); unset($bres); unset($ca_name);
$bsql = "SELECT bn_alt FROM yc4_banner WHERE bn_id = '$val[ca_name]'";
$bres = mysql_fetch_row(mysql_query($bsql));
$ca_name = iconv("euc-kr","utf-8",$bres[0]);
//$val['wr_id'] = "a10_".$val['wr_id'];
$val['group_id'] = "a10_".$val['group_id'];
$val['wr_4'] = iconv("euc-kr","utf-8",$val['wr_4']);
$val['wr_5'] = iconv("euc-kr","utf-8",$val['wr_5']);
$val['wr_7'] = iconv("euc-kr","utf-8",$val['wr_7']);
$val['ca_name'] = "<img src='/data/banner/$val[ca_name]' border='0' align='absmiddle'> <font color='1a8502'>$ca_name <font color='494646'>($val[wr_7])";
$arr[] = $val;
$sort_arr[] = strtotime($val[wr_6]) ;//2004-02-01 형식인경우 //time 으로 저장하경우 strtotime 제거
}
$sql = "SELECT * FROM g4_write_a20 where deleted = '0000-00-00 00:00:00'";
$res = mysql_query($sql);
while($val = mysql_fetch_assoc($res)){
$val['sca'] = $val['bo_table'];
unset($bsql); unset($bres); unset($ca_name);
$bsql = "SELECT bn_alt FROM yc4_banner WHERE bn_id = '$val[ca_name]'";
$bres = mysql_fetch_row(mysql_query($bsql));
$ca_name = iconv("euc-kr","utf-8",$bres[0]);
//$val['wr_id'] = "a20_".$val['wr_id'];
$val['group_id'] = "a20_".$val['group_id'];
$val['wr_4'] = iconv("euc-kr","utf-8",$val['wr_4']);
$val['wr_5'] = iconv("euc-kr","utf-8",$val['wr_5']);
$val['wr_7'] = iconv("euc-kr","utf-8",$val['wr_7']);
$val['ca_name'] = "<img src='/data/banner/$val[ca_name]' border='0' align='absmiddle'> <font color='c5d611'>$ca_name <font color='494646'>($val[wr_7])";
$arr[] = $val;
$sort_arr[] = strtotime($val[wr_6]) ;//2004-02-01 형식인경우 //time 으로 저장하경우 strtotime 제거
}
/* 이부분 추가*/
$temp_arr = array(); //추가
asort($sort_arr);
foreach ($sort_arr as $key => $val) {
$temp_arr[] = $arr[$key];
}
$arr = $temp_arr;
//추가 완료
echo json_encode($arr);
?>
처럼 하면 되지 않을까요
onlymilk74 님 감사합니다. 바로해결됬네요,...꾸벅..