½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > Ä¿¹Â´ÏƼ > Áú¹®°ú´äº¯ »ó¼¼º¸±â
Ä¿¹Â´ÏƼ ±¸Àα¸Á÷
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
Javascript
PHP
asp
CSS
HTML
mysql
jquery
image
Mobile
API
slide
°Ô½ÃÆÇ
¸Þ´º
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
°Ô½ÃÆÇŸÀÌƲ Áú¹®°ú´äº¯ / »ó¼¼º¸±â
Æ®À§ÅÍ·Î º¸³»±â
Ãßõ¼ö 45 | Á¶È¸¼ö 3,095 | µî·ÏÀÏ 2001-06-11 11:00:38

´Ð³×ÀÓ

vopos

À̸ÞÀÏ

vopos@happycgi.com

Á¦¸ñ

[´äº¯] [ÀçÁú¹®] °Ô½ÃÆÇ¿¡¼­ ´äº¯À» ÀúÀå...mysql....
³»¿ë
¾È³çÇϼ¼¿ä, 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°³°¡ µÈ´Ù¸é.... À̶§´Â ²¿¸®¿¡ ²¿¸®´Â ¹«´Â ......
>[Áú¹®]...
> [´äº¯]...
>
Ãßõ½ºÅ©·¦¼Ò½ºº¸±â ¸ñ·Ï
ÀÌÀü°Ô½Ã±Û ¹«·á °èÁ¤... 2001-06-10 19:51:47
´ÙÀ½°Ô½Ã±Û ¼øÀ§ »çÀÌÆ® ¼Ò½º ±¸ÇÕ´Ï´Ù. 2001-06-11 13:23:38