//ÇÁ·Î±×·¡¹ÖÀ» ÇÏ´Ùº¸¸é ¿©·¯ °Ô½ÃÆÇ¿¡¼ ³»¿ëÀ» °¡Á®¿Í¼ //´Ù ÇÔ²² ¹¾î¼ ƯÁ¤ Ä÷³À¸·Î µ¥ÀÌÅ͸¦ Á¤·ÄÇؾßÇÏ´Â °æ¿ì°¡ ¹ß»ýÇÒÅÙµ¥¿ä- //´ÙÀ½°ú °°Àº ¹æ¹ýÀ» »ç¿ëÇϸé ÁÁÀ» °Í °°½À´Ï´Ù. //DB ÀÚü·Î ¾î¶»°Ô Çغ¼ ¼öµµ ÀÖÀ» °Í °°Àºµ¥ ½Ç·ÂÀÌ µþ¸®³×¿ä- ¤¾¤¾^^
//¿ì¼± °Ô½ÃÆÇÀÇ Å×À̺í À̸§À» ¹è¿¿¡ ÀÔ·ÂÇÕ´Ï´Ù. $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); //¿©±â±îÁö Á¤·Ä
//ÀÚ¹Ù½ºÅ©¸³Æ®¸¦ ÀÌ¿ëÇؼ °Ô½ÃÆÇ ÇüÅ·Π¸¸µé ¼öµµ ÀÖ°í.. //µ¥ÀÌÅ͸¦ »Ì¾Æ³»¾î °¢Á¾ ¸ÞÀÎȸ鿡 »Ñ¸± ¼öµµ ÀÖ½À´Ï´Ù. DB¿¡¼ Å×À̺íÀÌ Æ²¸®´Ù¸é Ä÷³Çü½ÄÀ» ¸ÂÃç¼ union all ·Î °¡Á®¿À¸é µË´Ï´Ù. Âü°íÁÖ¼Ò http://mysqlkorea.co.kr/sub.html?mcode=develop&scode=01&m_no=21523&cat1=13&cat2=380&cat3=401&lang=k
|