|
|
ÇöÀçÀ§Ä¡: ¸ÞÀÎ ÇØÇÇÆ÷·³ À¥µðºñ : °Ô½Ã¹° Àбâ |
|
|
  2001-06-04 (11:48:04) from 211.109.189.183 |
|
|
  ÀÛ¼ºÀÎ : vopos |
Á¶È¸¼ö : 10052    |
|
Á¦¸ñ : [´äº¯] [Áú¹®] °Ô½ÃÆÇ°Ë»öÈÄ ¸®½ºÆ®Ãâ·Â ¾Ë°í¸®ÁòÁß¿¡¼... |
>°Ô½ÃÆÇ¿¡¼....°Ë»öÀ» ÇÑÈÄ ¸®½ºÆ®¸¦ Ãâ·ÂÇÏÁö¿ä.... >¹°·Ð 1ÆäÀÌÁö ÀÌ»óÀ̾î¾ß ÇÏ°Ú±¸¿ä.... ÆäÀÌÁö´ç 10°³¾¿À̶ó°í >ÇßÀ»¶§.... °Ë»öµÈ ÀÚ·á°¡ 50°³¶ó¸é....5ÆäÀÌÁö¸¦ ¸¸µé¾î¾ß ÇÏÁö¾Ê°Ú½À´Ï±î? >ÀÌ·²¶§ ¾î¶»°Ô 5ÆäÀÌÁö¸¦ ³ª´²¼ º¸¿©ÁÖÁÒ? >¾î¶² ¾Ë°í¸®ÁòÀ» ÀÌ¿ëÇϳª¿ä?
¾È³çÇϼ¼¿ä, HappyCGI ÆÀÀÇ voposÀÔ´Ï´Ù.
ÀϹÝÀûÀ¸·Î Query¸¦ µÎ¹ø ÇØ¾ß ÇÕ´Ï´Ù. óÀ½¿¡´Â (°Ë»ö)°á°úÀÇ °¹¼ö¸¦ ¸ÕÀú ¾Ë¾Æ ³»°í (COUNT() ÀÌ¿ë) ´Ù¸¥ Çϳª´Â °¢ ÆäÀÌÁö¿¡ Ãâ·ÂµÉ °á°ú°ª Áß¿¡ ÆäÀÌÁö¿¡ µû¶ó Ãâ·ÂÇÒ °á°ú ½ÃÀÛºÎÅÍ ÀÏÁ¤ÇÑ °¹¼ö(10°³)¸¦ °¡Á®¿À´Â Äõ¸®¸¦ ÇؾßÇÕ´Ï´Ù.
Àüü°á°ú Áß ÀϺκи¸À» °¡Á®¿À´Â °ÍÀº limit ÇÔ¼ö¸¦ ¾²½Ã¸é ¹«³ÇÒ °Í °°½À´Ï´Ù.
¿¹> SELECT * FROM tbl_name LIMIT $offset,$limit
$offsetÀº ÃÑ °á°úÁß¿¡¼ ½ÃÀÛÇÒ ¹øÈ£ (0¿¡¼ ½ÃÀÛ), $limit Àº $offsetÀ» Æ÷ÇÔÇØ ¼ °¡Á®¿Ã ÃÑ ·¹ÄÚµåÀÇ °¹¼öÀÔ´Ï´Ù.
http://www.mysql.com/doc/S/E/SELECT.html
´ÙÀ½ ±ÛÀ» Âü°íÇÏ½Ã¸é µµ¿òÀÌ µÉ°Ì´Ï´Ù.
http://www.happycgi.com/forum/forum_detail.cgi?action=whole&thread=6028 http://www.happycgi.com/forum/forum_detail.cgi?thread=6998
°¨»çÇÕ´Ï´Ù.
- vopos
/---------------------------------------------------------------------------------------------------- ÀÚÁÖ¹¯´Â Áú¹® Æ÷·³°ú Æ÷·³°Ë»öÀ» ÀÌ¿ëÇϼż ºñ½ÁÇÑ Áú¹®ÀÇ ´äº¯ÀÌ ÀÖ´ÂÁö È®ÀÎÇÏ½Ã°í ±Û ¿Ã·ÁÁÖ½Ã±æ ºÎŹµå¸³´Ï´Ù. ----------------------------------------------------------------------------------------------------/
|
|
¸Þ¸ð |
|
³²°ÜÁø ¸Þ¸ð°¡ ¾ø½À´Ï´Ù.
|
|
   |
|
|