 |
|
|  |
¿©·¯ °Ô½ÃÆÇÀÇ °ªµéÀ» °¡Á®¿Í¼ Á¤·ÄÇϱâ |
|
|
 |
13³â Àü |
//¿ì¼± °Ô½ÃÆÇÀÇ Å×À̺í À̸§À» ¹è¿¿¡ ÀÔ·ÂÇÕ´Ï´Ù.
$temp_name_s[0] = "0001";
$temp_name_s[1] = "0002";
$i=0;
//DB ¿¬°á(DB ¿¬°á ÄÚµå´Â ¾Ë¾Æ¼.. ^^ »ý·«ÇÕ´Ï´Ù.)
foreach($temp_name_s as $temp_name){
$query_select = "select * from $temp_name order by -regday";
//°æ¿ì¿¡µû¶ó À§ Äõ¸®¿¡¼ limit¸¦ »ç¿ëÇϽô °ÍÀÌ ÁÁ½À´Ï´Ù.
$result = mysql_query($query_select);
//DB Ŭ·¡½º°¡ ÀÖÀ» °æ¿ì Ŭ·¡½º¸¦ »ç¿ëÇØ ÁÖ¼¼¿ä-- ^^
while($row = mysql_fetch_object($result)){
$bc[$i]['board_code'] = $temp_name;
$bc[$i]['no'] = $row->no;
$bc[$i]['writer'] = $row->writer;
$bc[$i]['subject'] = $row->subject;
$bc[$i]['regday'] = $row->regday;
/*´õ ¸¹Àº °Ô½ÃÆÇ Ä÷³µéÀÌ µé¾î°¥ °ÍÀÔ´Ï´Ù. ^^
°¢ °Ô½ÃÆÇ¿¡ ¸Â°Ô ³Ö¾îÁÖ¼¼¿ä*/
$i++;
}
}
//DB ´Ý±â(ÄÚµå´Â »ý·«ÇÕ´Ï´Ù.)
//¾Æ·¡ ºÎºÐÀÌ Áß¿äÇѵ¥¿ä regday·Î ¹è¿À» Á¤·ÄÇÕ´Ï´Ù.
//regday¿¡ ÀÇÇÑ ÀçÁ¤·Ä
foreach ($bc as $key => $row) {
$regday[$key] = $row['regday'];
}
array_multisort($regday, SORT_DESC, $bc);
//¿©±â±îÁö Á¤·Ä
//ÀÚ¹Ù½ºÅ©¸³Æ®¸¦ ÀÌ¿ëÇؼ °Ô½ÃÆÇ ÇüÅ·Π¸¸µé ¼öµµ ÀÖ°í..
//µ¥ÀÌÅ͸¦ »Ì¾Æ³»¾î °¢Á¾ ¸ÞÀÎȸ鿡 »Ñ¸± ¼öµµ ÀÖ½À´Ï´Ù. |
|
̵̧ : 650 |
̵̧
¸ñ·Ï
|
|
|  |
|