¿©·¯°Ô½ÃÆÇÀÇ °ªµéÀ»°¡Á®¿Í¼ Á¤·ÄÇϱâ,»çÀÌÆ®Á¦ÀÛÆÁ,±³À°¼¾ÅÍ.
¿©·¯°Ô½ÃÆÇÀÇ °ªµéÀ»°¡Á®¿Í¼ Á¤·ÄÇϱâ [3]
//ÇÁ·Î±×·¡¹ÖÀ» ÇÏ´Ùº¸¸é ¿©·¯ °Ô½ÃÆÇ¿¡¼ ³»¿ëÀ» °¡Á®¿Í¼ //´Ù ÇÔ²² ¹¾î¼ ƯÁ¤ Ä÷³À¸·Î µ¥ÀÌÅ͸¦ Á¤·ÄÇؾßÇÏ´Â °æ¿ì°¡ ¹ß»ýÇÒÅÙµ¥¿ä- //´ÙÀ½°ú °°Àº ¹æ¹ýÀ» »ç¿ëÇϸé ÁÁÀ» °Í °°½À´Ï´Ù. //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
|
week 09-04-18 17:44 Á¶È¸ : 3579 |
|
ȸ¿ø»çÁøÀÌ ¾ø½À´Ï´Ù.
µî·ÏµÈ ÀÚ±â¼Ò°³°¡ ¾ø½À´Ï´Ù.
|
¾ÇÇú¸´Ù ³ª»Û°ÍÀÌ ¹«ÇÃÀÔ´Ï´Ù. ´ñ±ÛÀ» ´Þ¾ÆÁֽô ¼¾½º!! ³ªÀDZÛ,Á¤º¸ Çϳª°¡ ¸¹Àº ÀÌÀÇ Å«ÈûÀÌ µË´Ï´Ù.
ÁÁÀº±Û¿¡´Â °¨»çÀÇ "Ãßõ¹öÆ°", °ø°¨°¡´Â ´ñ±Û¿¡´Â "°ø°¨¹öÆ°"À» ´·¯ÁÖ¼¼¿ä~ ³ª´©¸é Áñ°Å¿òÀÌ µÎ¹è^^~
|
|
|
°¨»çÇÕ´Ï´Ù~
|
|
|
|
|
|
|
|
°¨»çÇÕ´Ï´Ù
|
|
|
|
|
|
|
|
°¨»çÇÕ´Ï´Ù. Ȥ½Ã .netÀ¸·Î µÈ°ÍÀÌ ÀÖ´Ù¸é °øÀ¯ ºÎŹµå¸³´Ï´Ù.
|
|
|
|
|
"·Î±×ÀÎ" ÇÏ½Ã¸é ´ñ±ÛÀ» ³²±æ ¼ö ÀÖ½À´Ï´Ù.
»çÀÌÆ®Á¦ÀÛÆÁ
¸Å´ÏÁ®: ¹ÌÁ¤