2003³â 1¿ù 8ÀÏ ÀÌÈÄ 
¸ðµÎ ¸í  ¿À´Ã ¸í 
¸ÞÀÎ ÆäÀÌÁö  
Ä®·³ º¸±â  
Ä«Å÷ º¸±â  
°Ô½ÃÆÇ °¡±â  
»çÀÌÆ®¸Ê  
±×¹ÛÀÇ °Íµé  

°¡ÀÔÇϸé Á¤¸» ÆíÇÕ´Ï´Ù;;
¢ºÀÚÀ¯ °Ô½ÃÆÇ
Áú´ä °Ô½ÃÆÇ
À¯¿ëÇÑ Á¤º¸
 

QnA
¹¯°í ´äÇϱâ
Áú¹®Àü °Ë»öÀº ±âº»!!!
Áú¹® ³»¿ëÀº ÃÖ´ëÇÑ ÀÚ¼¼ÇÏ°í Á¤È®ÇÏ°Ô!!!!!

 ¾È³çÇϼ¼¿ä. ¿£ÁÒÀÇ °Ô½ÃÆÇÇϳª·Î °³ÀΰԽÃÆÇÁÖ±â Áú¹®¿ä.. ±Û °íÄ¡±â±Û Áö¿ì±â 
 Àç¿íÀÌ  posted at 2003-12-18 03:10:43
735 hits  2 comments
Guest is out of level
 ÆÛ¸Ó¸µÅ© : http://reedyfox.com/island.php/qna/280  [º¹»ç]
Ȩ¿¡ ¿Í¼­ ±ÛÀ» ½á´Þ¶ó°í ÇϽñ淡
ÀÌ·¸°Ô ±ÛÀ» ¾¹´Ï´Ù.

À½..
Á¦·Îº¸µå °Ô½ÃÆÇ Çϳª·Î °³ÀΰԽÃÆÇÀ» ÁÙ¼ö ÀÖ´Â ³»¿ë¿¡¼­ ¸»Àä...

±ÛÀ» º¸¸é..
-------------------------------------
¶ó´Â ºÎºÐÀÌ Àִµ¥, °Å±â¼­ºÎÅÍ Ãâ¹ßÇØ ¸ðµÎ 3±ºµ¥ÀÇ

........¾î¼±¸...."select * from $t_board"."_$id...........¾î¼±¸.....

°¡ ÀÖ½À´Ï´Ù. ±×°Í 3°³¸¦ °¢°¢ ÀÌ·¸°Ô ¹Ù²ãÁÝ´Ï´Ù.

....."select * from $t_board"."_$id where division='$division' and headnum<0 and ismember='$member[no]'......

....."select * from $t_board"."_$id where division=$division and headnum!=0 and ismember='$member[no]'.....

....."select * from $t_board"."_$id $s_que where ismember='$member[no]'.....

´«Ä¡ ±î¼Ì°ÚÁö¸¸ where¿¡ ismember='$member[no]' ¸¸ ´Þ¶û Ãß°¡ÇÑ °ÍÀÔ´Ï´Ù.
¶Ç Çϳª.....
----------------------------------
¶ó±¸ ¾²¿©Àִµ¥ Á¦°¡ ¾ÆÅ©·Î¿¡µðÆ®·Î ºÒ·¯¼­ º¸¸é
ismemberºÎÅÍ´Â ´Ù¸£³×¿ä...
                if ($select_arrange=="headnum"&&$desc=="asc") {
                        while($division_data=mysql_fetch_array($division_result)) {
                                $sum=$sum+$division_data[num];
                                $division=$division_data[division];
        
                                if($sum>=$start_num) {
                                        $start_num=$start_num-($sum-$division_data[num]);
                                        $_dbTimeStart = getmicrotime();
                                        $que="select * from $t_board"."_$id where division='$division' and headnum<0 order by headnum,arrangenum limit $start_num, $page_num";
                                        $result=mysql_query($que) or error(mysql_error());
                                        $_dbTime += getmicrotime()-$_dbTimeStart;
                                        $check1=1;
        
                                        $returnNum = mysql_num_rows($result);
        
                                        if($returnNum>=$page_num) {
                                                break;
                                        } else {
                                                if($division>1) {
                                                        $division--;
                                                        $minus=$page_num-$returnNum;
                                                        $_dbTimeStart = getmicrotime();
                                                        $que2="select * from $t_board"."_$id where division=$division and headnum!=0 order by headnum,arrangenum limit $minus";
                                                        $result2=mysql_query($que2) or error(mysql_error());
                                                        $_dbTime += getmicrotime()-$_dbTimeStart;
                                                        $check2=1;
ÀÌ·±½ÄÀ¸·Î µÇ¾îÀÖ¾î¿ä...
ismember °¡ ¾È³ª¿À±¸ order by .... ÀÌ·±½ÄÀ¸·Î...
Á¦°¡ ¹» À߸ø¾È°É±î¿ä..


  PRINT Text  PRINT HTML  

  Trackbacks for this Posting (0)
'»ý°¢Çϴ¼¶ ¹Ù´å°¡ - ¾È³çÇϼ¼¿ä. ¿£ÁÒÀÇ °Ô½ÃÆÇÇϳª·Î °³ÀΰԽÃÆÇÁÖ±â Áú¹®¿ä..'

LIST ALL   DELETE MODIFY            GO TO THE TOP

- ÀÌ±Û À§¿¡ ÀÖ´Â ±Û : Áú¹®ÇÒ ¶§ ÁÖÀÇ »çÇ×
- ÀÌ±Û ¾Æ·¡ ÀÖ´Â ±Û : Á¦·Îº¸µå ¹Ì´ÏÀ§´Ï½ºÅ²¿¡¼­...

Copyright 1999-2024 Zeroboard

 
»ý°¢ÇÏ´Â ¼¶, ¹Ù´å°¡´Â ¸®µð°¡ ¿î¿µÇÏ´Â °³ÀÎ Ä®·³ »çÀÌÆ®À̸ç ÀϺΠÄÁÅÙÃ÷´Â ¸®µð ¿ÜÀÇ ÇÊÁø¿¡ ÀÇÇØ ÀÛ¼ºµÇ¾ú½À´Ï´Ù. ÀÌ°÷ÀÇ ¸ðµç ÄÁÅÙÃ÷´Â Ãâó(Deep Link URL) ¹× ÀÛ°¡¸¦ ¸í½ÃÇÏ´Â Á¶°ÇÀ¸·Î ºñ»ó¾÷Àû ¿ëµµÀÇ ÀüÁ¦/º¹Á¦°¡ °¡´ÉÇÕ´Ï´Ù. ±×·¯³ª ÀÌ°÷¿¡ °ÔÀçµÈ ÄÁÅÙÃ÷ÀÇ ÃëÁö ¶Ç´Â ÀÛ°¡ÀÇ Àǵµ°¡ ¿Ö°îµÇ¾î Çؼ®µÉ ¼ö ÀÖ´Â ÄÁÅÙÃ÷ º¯ÇüÀº ±ÝÁöÇÕ´Ï´Ù. ÀÌ°÷¿¡ ±âÀçµÈ ÀüÀÚ¿ìÆíÁÖ¼Ò¿¡ ´ëÇÑ ÀÏüÀÇ ¼öÁýÇàÀ§¸¦ °ÅºÎÇÕ´Ï´Ù.(°Ô½ÃÀÏ 2008³â 1¿ù 1ÀÏ)
Google
  Á¤Çϳª - ¾îµð¼±°¡ º»µíÇÑ ³¸ÀÍÀ½  
Window close