Ȩ¿¡ ¿Í¼ ±ÛÀ» ½á´Þ¶ó°í ÇϽñ淡
ÀÌ·¸°Ô ±ÛÀ» ¾¹´Ï´Ù.
À½..
Á¦·Îº¸µå °Ô½ÃÆÇ Çϳª·Î °³ÀΰԽÃÆÇÀ» ÁÙ¼ö ÀÖ´Â ³»¿ë¿¡¼ ¸»Àä...
±ÛÀ» º¸¸é..
-------------------------------------
¶ó´Â ºÎºÐÀÌ Àִµ¥, °Å±â¼ºÎÅÍ Ãâ¹ßÇØ ¸ðµÎ 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 .... ÀÌ·±½ÄÀ¸·Î...
Á¦°¡ ¹» À߸ø¾È°É±î¿ä..
|