¿©·¯°Ô½ÃÆÇÀÇ °ªµéÀ»°¡Á®¿Í¼ Á¤·ÄÇϱâ
week
Á¶È¸ : 3,580
//ÇÁ·Î±×·¡¹ÖÀ» ÇÏ´Ùº¸¸é ¿©·¯ °Ô½ÃÆÇ¿¡¼ ³»¿ëÀ» °¡Á®¿Í¼
//´Ù ÇÔ²² ¹¾î¼ ƯÁ¤ Ä÷³À¸·Î µ¥ÀÌÅ͸¦ Á¤·ÄÇؾßÇÏ´Â °æ¿ì°¡ ¹ß»ýÇÒÅÙµ¥¿ä-
//´ÙÀ½°ú °°Àº ¹æ¹ýÀ» »ç¿ëÇϸé ÁÁÀ» °Í °°½À´Ï´Ù.
//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
//´Ù ÇÔ²² ¹¾î¼ ƯÁ¤ Ä÷³À¸·Î µ¥ÀÌÅ͸¦ Á¤·ÄÇؾßÇÏ´Â °æ¿ì°¡ ¹ß»ýÇÒÅÙµ¥¿ä-
//´ÙÀ½°ú °°Àº ¹æ¹ýÀ» »ç¿ëÇϸé ÁÁÀ» °Í °°½À´Ï´Ù.
//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