¸®µð´Ô ¾È³çÇϼ¼¿ä. ÷ ±ÛÀ» ¾²´Âµ¥ ´ë¶ä,,Áú¹®À̳׿ä.
Á˼ÛÇÕ´Ï´Ù,,,
¸Ç³¯ ÁÁÀº ÆÁ¸¸ º¸°í ÆÛ°¡±â¸¸ ÇßÁö ±ÛÀ» ³²±âÁö ¾ÊÀº,,,
À̹øÀ» °è±â·Î ÀÚÁÖ µé¸£°Ú½À´Ï´Ù. ^^
À½,,´ë¶ä µå¸®´Â Áú¹®Àº,,,"MY VIEW ±â´É"¿¡ ´ëÇÑ Áú¹®ÀÔ´Ï´Ù.
http://reedyfox.com/bbs/view.php?id=building&page=2&sn1=&divpage=1&sn=off&ss=on&sc=on&select_arrange=headnum&desc=asc&no=47&read.html
¾Ë·ÁÁֽŠÅÇ´ë·Î myboard.php µµ ¸¸µé¾ú°í
_head.php ÆÄÀÏ¿¡ myboard.phpµµ Ãß°¡Çß½À´Ï´Ù.
±×¸®°í Å×½ºÆ® °Ô½ÃÆÇÀÇ view.php¿¡ <?php if($member[no]) { echo "
MY VIEW"; } ?> ¿ä·¸°Ô Ãß°¡¸¦ Çß½À´Ï´Ù.
Çåµ¥ ¿ä±â¼ ¹®Á¦°¡,,,^^
// °Ë»ö Á¶°ÇÀÌ ¾øÀ»¶§ : »óȲ -> ÀÏ¹Ý Á¤·Ä, ¶Ç´Â Á¤·Ä±âÁØÀ» °¡Áö°Å³ª Desc, Asc À϶§.
¶ó´Â ºÎºÐÀÌ Àִµ¥, °Å±â¼ºÎÅÍ Ãâ¹ßÇØ ¸ðµÎ 3±ºµ¥ÀÇ
À ºÎºÐ¿¡¼ Á¦°¡ °è¼Ó ÇظŰí Àִµí ÇÕ´Ï´Ù.
Á¦ myboard.php ÆÄÀÏ¿¡¼ À ºÎºÐÀº ¾Æ·¡¿Í °°Àºµ¥ ¿©±â,,,Àú±â¿¡
ismember='$member[no]' ¸¦ Ãß°¡ÇغÁµµ µµÅë,,¹ÝÀÀÀÌ,,,^^
$que="select * from $t_board"."_$id where division='$division' and headnum<0 order ismember='$member[no]' by headnum,,,ÀÌÇÏ »ý·«
$que2="select * from $t_board"."_$id where division=$division and headnum!=0 order ismember='$member[no]' by headnum,,,ÀÌÇÏ »ý·«
$que="select * from $t_board"."_$id $s_que order ismember='$member[no]' by $select_arrange $desc $add_on limit $start_num, $page_num"; ,, ÀÌÇÏ »ý·«
[ Ãß°¡ºÎºÐ ]
Àú´Â Çѱºµ¥ ´õ ÀÖ´õ¶ó±¸¿ä. ±Ùµ¥ ÀÏ´Ü ±× ºÎºÐ¿¡´Â Ãß°¡¸¦ ¾ÈÇß½À´Ï´Ù.
$board_result=mysql_query("select no,name from $admin_table where no!='$setup[no]'");
¾Æ¹«·¡µµ ³Ö¾îÁØ ºÎºÐÀÌ Æ²¸°°Å °°Àºµ¥ ¾îµòÁö¸¦ ¸øã°í ÀÖ½À´Ï´Ù. ^^
È¥ÀÚ¼ ¾ÈÇغ»°Ç ¾Æ´Ï°í 30ºÐ° ÀÌ°Í,,Àú°Í ÇغÁµµ µµÅë,,^^
¾Æ¸¶ Å×½ºÆ®°Ô½ÃÆÇÀÇ ¾Æ¹«±ÛÀ̳ª Ŭ¸¯ÇϽðí Áß°£Âë¿¡ "MY VIEW" ¶ó´Â ¹®±¸¸¦ Ŭ¸¯ÇØ º¸½Ã¸é ¾Æ½Ç°Ì´Ï´Ù.
http://ganji.80port.net/bbs/myboard.php?id=newja
¿ä·± ¸Þ½ÃÁö¸¸ ³ª¿À³×¿ä ^^
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ismember='1' by headnum,arrangenum limit 0, 20' at line 1
´Ù½ÃÇѹø ´ë¶ä Áú¹®¸¸ µå·Á¼ Á˼ÛÇÕ´Ï´Ù. (__)
´ã¿¡´Â Áú¹®ÀÌ ¾Æ´Ñ ÁÁÀº ÆÁÀÌ¶óµµ °¡Á® ¿À°Ú½À´Ï´Ù. ^^
Ç×»ó °Ç°ÇϽðí ÇϽô ¸ðµç ÀϵéÀÌ Àߵǽñ⸦ ¹Ù¶ø´Ï´Ù.