|
Total related article : 4 |
|
µî·ÏÀÏ: | 2001-06-08 |
½Ã°£: | 22:52:59 |
Á¶È¸¼ö: | 3676 |
from: | 211.186.163.241 |
|
[Áú¹®] °Ô½ÃÆÇ¿¡¼ ´äº¯À» ÀúÀå...mysql.... |
±Û¾´ÀÌ : Anonymous |
|
°Ô½ÃÆÇ¿¡¼ ´äº¯À» happycgi¿Í °°ÀÌ Áú¹® ¹Ù·Î ¹Ø¿¡ Ãâ·ÂÀÌ µÇ°Ô ÇÏ·Á°í Çϴµ¥¿ä.... mysql¿¡¼ µ¥ÀÌÅ͸¦ »ðÀÔÇÒ¶§ insert into Çϸé Á¦ÀÏ ¹Ø¿¡ Â÷·Ê´ë·Î ½×ÀÌÀÚ³ª¿ä? ¾î¶»°Ô Áú¹®-´äº¯À» ±¸ÇöÇØ ³¾¼ö ÀÖÁÒ?
|
|
   |
|
µî·ÏÀÏ: | 2001-06-09 |
½Ã°£: | 11:02:26 |
Á¶È¸¼ö: | 4035 |
from: | 211.33.8.94 |
|
[´äº¯] [Áú¹®] °Ô½ÃÆÇ¿¡¼ ´äº¯À» ÀúÀå...mysql.... |
±Û¾´ÀÌ : vopos |
|
>°Ô½ÃÆÇ¿¡¼ ´äº¯À» happycgi¿Í °°ÀÌ Áú¹® ¹Ù·Î ¹Ø¿¡ Ãâ·ÂÀÌ µÇ°Ô ÇÏ·Á°í >Çϴµ¥¿ä.... mysql¿¡¼ µ¥ÀÌÅ͸¦ »ðÀÔÇÒ¶§ insert into Çϸé >Á¦ÀÏ ¹Ø¿¡ Â÷·Ê´ë·Î ½×ÀÌÀÚ³ª¿ä? >¾î¶»°Ô Áú¹®-´äº¯À» ±¸ÇöÇØ ³¾¼ö ÀÖÁÒ?
¾È³çÇϼ¼¿ä, HappyCGI ÆÀÀÇ voposÀÔ´Ï´Ù.
ÀÌÀü¿¡ ºñ½ÁÇÑ Áú¹®¿¡ ´ëÇÑ ±ÛÀÌ ÀÖ¾ú´Âµ¥ ¾Æ¹«¸® ãÀ»·¡µµ ¾ÈµÇ´Â±º¿ä.
Æ÷·³½º·¹µå¸¦ Çس»´Â ¹æ¹ýÀº ¸î°¡Áö°¡ Àִ°ɷΠ¾Æ´Âµ¥ ÇØÇÇ¿¡¼ »ç¿ëÇÏ´Â ¹æ½Ä À» °£´ÜÇÏ°Ô ¼³¸íµå¸®°Ú½À´Ï´Ù.
¸ÕÀú Æ÷·³Å×ÀÌºí¿¡ ½º·¹µåÇü½ÄÀ» À§ÇØ ÇÊ¿äÇÑ Ä÷³À» ´ÙÀ½Ã³·³ Àâ½À´Ï´Ù.
articleId INT AUTO_INCREMENT PRIMARY KEY, threadId INT NOT NULL, replyId CHAR(50) NOT NULL,
articleId => ±ÛÀÇ °íÀ¯ÇÑ ¹øÈ£ threadId´Â => ¾î¶² ½º·¹µåÀÇ ÃÖ»óÀ§ ±ÛÀÇ articleId
replyId´Â "¼ýÀÚ-¼ýÀÚ-¼ýÀÚ" Çü½ÄÀÔ´Ï´Ù. ¸¸ÀÏ articleIdÀÇ Ã¹¹ø° ´äº¯±ÛÀº 1-01, µÎ¹ø° ´äº¯±ÛÀº 1-02, articleId 1ÀÇ ´äº¯±ÛÀÇ ´äº¯±ÛÀº 1-01-01, ´äº¯±ÛÀÇ µÎ¹ø ° ´äº¯±ÛÀº 1-01-02°¡ µÇ´ÂÇü½ÄÀÔ´Ï´Ù.
¾î¶² ±ÛÀÇ Æ¯Á¤ ±íÀÌ(depth)ÀÇ ´äº¯±ÛÀÌ ¸î°³ÀÎÁö¸¦ ¾Ë¾Æ³»¾ß°ÚÁÒ? ±×·¡¾ß ±× °¹ ¼ö¿¡ ¶§¶ó ¹øÈ£¸¦ ¸Å°Ü ÀúÀåÀ» Çؾߴϱî¿ä. ±×°Ç Á÷Á¢Çغ¸¼¼¿ä, Àç¹ÌÀÖÀ»°Ì´Ï´Ù.
½º·¹µå ¸®½ºÆ®¸¦ Ãâ·ÂÇÒ ¶§´Â ¿ä·±½ÄÀ¸·Î...
SELECT * FROM tbl_name ORDER BY threadId DESC,replyId;
¼³¸íµå¸° ¹æ½ÄÀº ÀúÀåÇϱⰡ ÈûµéÁö¸¸ ½º·¹µå Ãâ·ÂÀº °£´ÜÇÏ´Ù´Â ÀåÁ¡ÀÌ ÀÖ½À´Ï´Ù.
°¨»çÇÕ´Ï´Ù.
- vopos
/---------------------------------------------------------------------------------------------------- ÀÚÁÖ¹¯´Â Áú¹® Æ÷·³°ú Æ÷·³°Ë»öÀ» ÀÌ¿ëÇϼż ºñ½ÁÇÑ Áú¹®ÀÇ ´äº¯ÀÌ ÀÖ´ÂÁö È®ÀÎÇÏ½Ã°í ±Û ¿Ã·ÁÁÖ½Ã±æ ºÎŹµå¸³´Ï´Ù. ----------------------------------------------------------------------------------------------------/
|
|
   |
|
µî·ÏÀÏ: | 2001-06-09 |
½Ã°£: | 16:23:01 |
Á¶È¸¼ö: | 3491 |
from: | 211.229.87.187 |
|
      [ÀçÁú¹®] °Ô½ÃÆÇ¿¡¼ ´äº¯À» ÀúÀå...mysql.... |
±Û¾´ÀÌ : Anonymous |
|
³×..... articleId INT AUTO_INCREMENT PRIMARY KEY, threadId INT NOT NULL, replyId CHAR(50) NOT NULL, ¿©±â¼....articleld ´Â.... ±ÛÀÇ ¹øÈ£.... ±Ùµ¥...µÚ¿¡ AUTO_INCREMENT´Â... ¹¹ÁÒ? ±×¸®°í ÀÌ ¹øÈ£¿¡ PRIMARY KEY¸¦ ¼³Á¤ÇÏ´Â ÀÌÀ¯°¡ ¹¹Áö¿©?
threadld °³³äÀ» Àß ÀÌÇظøÇϰڴµ¥¿©....
replyld´Â ´ëÃæÀÌÇØ°¡´Âµ¥¿ä....¸¸¾à ±×°Ô Áú¹®À̶ó¸é replyld¿¡´Â ±×³É ±× Áú¹®ÀÇ ¹øÈ£¸¸ µé¾î°¡°Ô µÇ´Â°Ç°¡¿ä? ±×¸®°í ¸¸¾à Áú¹®¿¡ ´ëÇÑ ´äº¯ÀÌ... ÇÑ 100°³°¡ µÈ´Ù¸é.... À̶§´Â ²¿¸®¿¡ ²¿¸®´Â ¹«´Â ...... [Áú¹®]... [´äº¯]... [´äº¯]...
½ÄÀ¸·Î... ÀÌ·¸°Ô µÇ¾úÀ»¶§.... char(50)ÀÇ ¹üÀ§¸¦ ¹þ¾î³ª¸é ¾î¶»°Ô µË´Ï±î? µµ¿ò ¿äûÇÕ´Ï´Ù.
~-. ¾î´À ½Ã°ñ¿¡¼.......
|
|
   |
|
µî·ÏÀÏ: | 2001-06-11 |
½Ã°£: | 11:00:38 |
Á¶È¸¼ö: | 3669 |
from: | 211.33.8.94 |
|
           [´äº¯] [ÀçÁú¹®] °Ô½ÃÆÇ¿¡¼ ´äº¯À» ÀúÀå...mysql.... |
±Û¾´ÀÌ : vopos |
|
¾È³çÇϼ¼¿ä, HappyCGI ÆÀÀÇ voposÀÔ´Ï´Ù.
>³×..... >articleId INT AUTO_INCREMENT PRIMARY KEY, >threadId INT NOT NULL, >replyId CHAR(50) NOT NULL, >¿©±â¼....articleld ´Â.... ±ÛÀÇ ¹øÈ£.... ±Ùµ¥...µÚ¿¡ AUTO_INCREMENT´Â... >¹¹ÁÒ? ±×¸®°í ÀÌ ¹øÈ£¿¡ PRIMARY KEY¸¦ ¼³Á¤ÇÏ´Â ÀÌÀ¯°¡ ¹¹Áö¿©?
AUTO_INCREMENT ´Â DB ¼¹ö¿¡¼ Á¦°øÇÏ´Â ±â´ÉÀ¸·Î Ä÷³Å¸ÀÔÀÌ ¼ýÀÚÀÌ¸é »õ µ¥ÀÌ Å¸°¡ ÀԷµɶ§ ÀÚµ¿À¸·Î ¼ýÀÚ¸¦ Çϳª Áõ°¡½ÃÄÑ ±â·ÏÇØÁÝ´Ï´Ù.
°¡Àå ÃÖ±Ù¿¡ ±â·ÏµÈ articleId°¡ 33ÀÌ¸é ±× ´ÙÀ½¿¡ ±â·ÏµÇ´Â ·¹ÄÚµåÀÇ articleId ´Â ÀÚµ¿À¸·Î 34°¡ µË´Ï´Ù. Insert ÇÒ ¶§ articleId¸¦ ¾î¶»°Ô Áà¾ßÇÒÁö °í¹ÎÇÏÁö ¾Ê¾Æµµ µÇ°ÚÁÒ?
Å×ÀÌºí¿¡¼ °íÀ¯ÇÑ ·¹Äڵ带 ±¸ºÐÇÏ´Â Ä÷³ÀÌ ÀÖ¾î¾ßÇϴϱî articleId Ä÷³À¸·Î ±ÛÀÇ °íÀ¯ÇÑ ¹øÈ£¸¦ ºÎ¿©Çϴ°̴ϴÙ. ÀÌ ¶§ ±× Ä÷³À» Primary Key ¶ó°í ÇÕ´Ï´Ù.
>threadld °³³äÀ» Àß ÀÌÇظøÇϰڴµ¥¿©....
±ÛÀÇ ±×·ìÀ̶ó°í »ý°¢Çϼ¼¿ä. ¾î´À ±Û¿¡ ´äº¯ÀÌ ÀÖ°í ¶Ç ´äº¯ÀÌ µîµî, ÀÖÀ»¶§ ±× °ü·ÃµÈ ±Û Àüü¸¦ ÇϳªÀÇ ±×·ìÀ̶ó°í ÇսôÙ. ±× ±×·ìÀÇ ¸ðµç ±ÛÀº °°Àº ½º·¹ µå¾ÆÀ̵𸦠°®°Ô µÇ´Â°ÅÁÒ.
articleId°¡ 1ÀÎ ±Û¿¡ ÆÄ»ýµÇ´Â ¸ðµç ±ÛÀÇ threadId´Â °¡Àå ÃÖ»óÀ§ ±ÛÀÇ articleId ·Î ÁÝ´Ï´Ù. ±×·¯¸é ±× ±×·ì ¸ðµç ±ÛµéÀÇ threadId´Â 1ÀÌ µË´Ï´Ù. °Ô½ÃÆÇ ½º·¹µå¸¦ º¸¿©ÁÙ ¶§ "order by threadId desc" ºÎºÐ°ú ¿¬°üÁö¾î »ý°¢Çϸé ÀÌÇØ°¡...
>replyld´Â ´ëÃæÀÌÇØ°¡´Âµ¥¿ä....¸¸¾à ±×°Ô Áú¹®À̶ó¸é replyld¿¡´Â ±×³É >±× Áú¹®ÀÇ ¹øÈ£¸¸ µé¾î°¡°Ô µÇ´Â°Ç°¡¿ä? ±×¸®°í ¸¸¾à Áú¹®¿¡ ´ëÇÑ ´äº¯ÀÌ... >ÇÑ 100°³°¡ µÈ´Ù¸é.... À̶§´Â ²¿¸®¿¡ ²¿¸®´Â ¹«´Â ...... >[Áú¹®]... > [´äº¯]... >
|
|
   |