0
 829   42   8
  View Articles

Name  
   ¿À¼®Áø  (2004-04-27 13:00:14, Hit : 8537, Vote : 1809)
Subject  
   ¿À·£¸¸¿¡ Áú¹®µå¸³´Ï´Ù.
¾ß±¸±â·Ï½Ç °ü·ÃÇØ¼­ ¿©·¯°¡Áö Áú¹®µå·È´ø »ç¶÷ÀÔ´Ï´Ù.
¼Õº´¸ñ´Ô°ú µÎ¸®¹¶½Ç´Ô ´öºÐ¿¡ ¼º°øÇß½À´Ï´Ù.^.^ Áö±Ý ĪÂùÀÌ ÀÚÀÚÇÕ´Ï´Ù.
À߸¸µé¾ú´Ù°í¿ä.. °¨»çµå¸³´Ï´Ù.

±â·ÏÁ¤·Ä°ú °ü·ÃµÇ¾î¼­ Áú¹®ÀÌ À־ ±ÛÀ» ³²±é´Ï´Ù.

http://www.yagootj.com/record_batter/list_batter.php

Áú¹®1. ´©ÀûŸÀ²°è»ê½Ã ¼Ò¼öÁ¡ 3ÀÚ¸®±îÁö Ç¥½ÃÇÏ·Á¸é...========================================
ab->Ÿ¼ö hit->¾ÈŸ

$query="select sum(ab) as s_ab,sum(hit) as s_hit,sum(hit)/sum(ab) as s_hra from $tablename  ".$que_league." ".$and." ".$que_team1." GROUP BY name,team1,league order by $select_arrange_s $desc limit $offset, $list_num";

ÀÌ·¯ÄÉÇϴϱî s_hra°ªÀÌ ¼Ò¼öÁ¡ µÎÀÚ¸®°ªÀ¸·Î Á¤ÇØÁ® ¹ö¸®´õ¶ó±¸¿ä.
$s_hra = (number_format($array[s_hra],3));
À̺¯¼ö¸¦ Ãß°¡Çصµ ¼¼ÀÚ¸®¼Ò¼öÁ¡Àº 0À¸·ÎÇ¥½Ã°¡µË´Ï´Ù.

±×·¡¼­ sum(hit)/sum(ab) as s_hraÀ» ¾ø¾Ö°í
$s_hra = (number_format($array[s_hit]/$array[s_ab],3)); ¸¦ ³ÖÀ¸¸é
¼Ò¼öÁ¡ 3ÀÚ¸®±îÁö Á¤»óÇ¥½ÃµÇ±äÇϴµ¥, s_hitÇϰí s_ab°ªÀÌ 0 ÀÎ ¼±¼ö´Â

Warning: Division by zero in /home/triple/yagootj/record_batter/list_batter.php on line 339

ÀÌ·±½ÄÀ¸·Î °è»ê¿À·ù¶ó°í ¶ß´õ±º¿ä.
°è»ê¿À·ùµµ ¾È¶ß°Ô ÇÏ°í ¼Ò¼öÁ¡ 3ÀÚ¸®±îÁö Ç¥½ÃµÇ°Ô Çϴ¹æ¹ýÀÌ ¾øÀ»±î¿ä?

Áú¹®2.-==================================================================================
±â·ÏÀ» s_hra ¿¡ ÀÇÇØ Á¤·Ä½ÃÄ״µ¥, s_ab °ª°ú s_hit°ªÀÌ 0ÀÎ ¼±¼ö°¡ ÃÖ»óÀ§·Î Á¤·ÄÀÌ µÇ´õ±º¿ä. ¾Æ¸¶ 0/0 ÀÌ¸é ¹«ÇÑ´ë°¡ Ç¥½ÃµÇ¼­ ±×·±°Å °°Àºµ¥ ÇØ°á¹æ¹ýÀº ¾ø´ÂÁö¿ä.

Áú¹®3. Á¤·Ä¼ø¼­ÀÇ º¹¼öÁöÁ¤..===============================================================
ÇöÀç ÃʱâÁ¤·Ä°ªÀÌ  s_hraÀÔ´Ï´Ù. À̶§ s_hra °ªÀÌ °°Àº µÎ¼±¼ö°¡ ÀÖÀ»¶© s_hit°ªÀÌ ´õÅ« ¼±¼ö¸¦ »óÀ§ Á¤·Ä½Ã۰íÀÚ ÇÕ´Ï´Ù.

Áï.-----s_ab    s_hit    s_hra
°­È£µ¿   12         6        0.500
À¯Àç¼®   10         5        0.500

s_hra°ªÀÌ °°À¸¸é s_hit°ªÀÌ Å«¼±¼ö¸¦ »óÀ§Á¤·Ä½ÃŰ·Á°íÇÕ´Ï´Ù.
  
Áú¹®4. ±ÔÁ¤Å¸¼ö ¿ì¼±Á¤·Ä===================================================================
3¹øÁú¹®°ú ºñ½ÁÇÑ ³»¿ëÀÌ µÉ°Í °°Àºµ¥¿ä.
s_ab°ªÀÌ Á¤ÇØÁø ¼ýÀÚ(±ÔÁ¤Å¸¼ö-º¯¼öó¸®) ÀÌ»óÀÎ ¼±¼ö¸¦ ¿ì¼±ÀûÀ¸·Î Á¤·ÄÇÑ´ÙÀ½, Á¤ÇØÁø¼ýÀÚÀÌÇÏÀÎ ¼±¼ö¸¦ ±×ÀÌÇÏ·Î Á¤·ÄÇϴ¹æ¹ýÀº ¾ø´ÂÁö¿ä.

Áú¹®5. ¼øÀ§ ¸Å±â±â=========================================================================
ÀÌ°Ç Á¦°¡ ÇØºÁ¼­ ¼øÀ§¸Å±â±â´Â °¡´ÉÇߴµ¥.. ¼ø¼­´ë·Î ±×³É ÁÖ¿í---1,2,3,4,---ÀÌ·¯ÄÉ 됬½À´Ï´Ù.
ÀÌ·¯ÄÉ º¯¼öó¸® Ç߰ŵç¿ä
$no=0;
$no=$no+1;

http://www.yagootj.com/record_result/list_rank.php?league=4

½Â·ü¿¡ ÀÇÇØ Á¤·Ä½ÃŰ·Î ±×¿¡ µû¶ó ¼øÀ§¸¦ ºÎ¿©Çߴµ¥¿ä.

½Â·üÀÌ °°À¸¸é °°Àº¼øÀ§°¡ Ç¥½ÃµÇ°Ô ÇÏ·Á°í ÇÕ´Ï´Ù.

¼øÀ§   ÆÀ     ½Â·ü ----
1       A      1.000
1       B      1.000
1       C      1.000
4       D       0.900      
4       E       0.900
6       F        0.800

ÀÌ·±½ÄÀ¸·Î Ç¥ÇöµÇ°Ô ÇÏ·Á°í ÇÕ´Ï´Ù.
¾î¶»°Ô ÇØ¾ß ÇÒ·±Áö¿ä..
=========================================================================================
¿À´Ã ³Ê¹« ¸¹Àº Áú¹®À» µå·È³×¿ä.. ±×µ¿¾È È¥ÀÚ¼­ ²þ²þ´ë´Ù°¡ ³Ê¹« ¾ÈÇ®·Á¼­ µµ¿òÀ» ±¸ÇÕ´Ï´Ù. ^.^
Ç×»ó Ä£ÀýÇÑ ´äº¯ °¨»çµå¸³´Ï´Ù ²Ù¹÷

¼Õº´¸ñ
¸ÕÀú, Áú¹® 1¹ø¿ä.
select sum(ab) as s_ab,sum(hit) as s_hit,sum(hit)/sum(ab) as s_hra..... ¿¡¼­
sum(hit)/sum(ab) ºÎºÐÀ» round(sum(hit)/sum(ab),3)¿Í °°ÀÌ ¹Ù²ãº¸¼¼¿ä. ¾Æ¸¶ µÉ °Ì´Ï´Ù.
 2004/05/04 09:35:13    

¼Õº´¸ñ
Áú¹® 2´Â, ÀÌÇØ°¡ Àß ¾ÈµË´Ï´Ù.
0Ÿ¼ö 0¾ÈŸÀÇ °ªÀº ¾ö°ÝÇÏ°Ô ¸»ÇÏ¸é ¿À·ùÀε¥, ½ÇÁ¦ s_hra°ª¿¡´Â NULL °ªÀÌ ÀԷµ˴ϴÙ. µû¶ó¼­ NULLÀÇ °ªÀº 0º¸´Ù ÀÛ°Ô Ãë±ÞµÇ¾î, ³»¸²Â÷¼øÀ¸·Î Á¤·ÄÇÏ¸é °¡Àå ³·°Ô, ¿Ã¸²Â÷¼øÀ¸·Î Á¤·ÄÇÏ¸é °¡Àå ³ô°Ô Ç¥½ÃµË´Ï´Ù.
Á¦°¡ Å×½ºÆ®Çغ» °á°ú ±×·¸½À´Ï´Ù.
 2004/05/04 09:46:48    

¼Õº´¸ñ
Áú¹® 3Àº °£´ÜÇÕ´Ï´Ù.
s_hra ±âÁØÀ¸·Î ³»¸²Â÷¼ø, s_hit ±âÁØÀ¸·Î ³»¸²Â÷¼øÀ» µ¿½Ã¿¡ Àû¿ëÇÏ¸é µË´Ï´Ù.
ORDER BY s_hra DESC, s_hit DESC ¶ó°í ÇÏ¸é µË´Ï´Ù.
 2004/05/04 09:49:38    

¼Õº´¸ñ
Áú¹® 4´Â 3¹ø ´äº¯À» º¸°í ÀÀ¿ëÇØ º¸½Ã¸é µÉ °Í °°³×¿ä.  2004/05/04 09:50:42    

½Ãµð¸Ç
Áú¹® 1,3¹øÀº ÇØ°á됬½À´Ï´Ù. Á¤¸» ³Ê¹«³Ê¹« °¨»çÇÕ´Ï´Ù. ^.^

Áú¹® 2ÀÇ °æ¿ì
http://www.yagootj.com/record_batter/list_batter.php?league=2 ÀÇ °æ¿ìÀÔ´Ï´Ù. 0Ÿ¼ö 0¾ÈŸÀÇ ¼±¼ö°¡ °¡ÀåÀ§¿¡ Á¤·ÄÀÌ µË´Ï´Ù.
$query="select Áß·« name,sum(ab) as s_abi,sum(hit) as s_hit,round(sum(hit)/sum(ab),3) as s_hra Áß·« from $tablename ".$que_league." ".$and." ".$que_team1." GROUP BY name,team1,league order by $select_arrange_s desc, s_hit DESC limit $offset, $list_num"; // SQL Äõ¸®¹®

$select_arrange_s ÀÇ º¯¼ö󸮴 ´ÙÀ½°ú °°ÀÌ Çß½À´Ï´Ù.
if($select_arrange_s=="") {$select_arrange_s="s_hra";}
====================================================
5¹øÁú¹®¿¡ ´ëÇÑ ´äµµ ºÎʵ右´Ï´Ù.^.^
Ç×»ó °¨»çÇÕ´Ï´Ù.
 2004/05/05 00:38:26    

¼Õº´¸ñ
Áú¹® 5¿¡ ´ëÇÑ ´äÀÌ Á» ´Ê¾ú³×¿ä. Á˼ÛÇÕ´Ï´Ù.

ÀÌ°Ç ¼³¸íÀÌ Á» º¹ÀâÇÕ´Ï´Ù. ¹è¿­À» ÀÌ¿ëÇØ¾ßÇÒ °Í °°³×¿ä.

¸¸¾à ½Â·üÀÇ °ªÀÌ $ÇöÀç½Â·ü¿¡ ÀúÀåµÈ´Ù°í °¡Á¤ÇÕ´Ï´Ù. Áö³­ ½Â·ü,Áï ¹Ù·Î ÀüÀÇ ½Â·üÀº $½Â·ü¿¡ ÀúÀåµÈ´Ù°í °¡Á¤Çϱ¸¿ä.
¼øÀ§´Â $grade ¹è¿­º¯¼ö¸¦ »ç¿ëÇÕ´Ï´Ù(ÇöÀç´Â $no¸¦ »ç¿ëÇßÁÒ?). ´ë½Å $no´Â ÷ÀÚ·Î »ç¿ëÇÕ´Ï´Ù.
$no´Â ´Ü¼øÇÑ ¼ø¼­¸¸À» ³ªÅ¸³À´Ï´Ù. µû¶ó¼­ $grade[1]À̸é ù¹øÂ° °ªÀÇ ¼øÀ§¶ó´Â ¶æÀÌÁÒ. ÀÌ°Ç ´ç¿¬È÷ 1ÀÌ µÇ°ÚÁÒ.
$grade[2]´Â µÎ¹øÂ° ¼øÀ§¶ó´Â ¶æÀε¥, À̰ÍÀº 2°¡ µÉ ¼öµµ ÀÖ°í ù¹øÂ° °ª°ú µ¿ÀÏÇϸé 1ÀÌ µÉ ¼öµµ ÀÖ´Â °Ì´Ï´Ù.

¿¹¸¦ µé¾î, ¸¸¾à $no°¡ 1À̸é

$grade[$no] = $no ; // ¡æ $grade[1] = 1; °ú µ¿ÀÏÇÑ ¶æÀÔ´Ï´Ù.

½Â·üÀÌ ¸ðµÎ ´Ù¸£´Ù¸é,

$grade[2] = 2
$grade[3] = 3 °ú °°ÀÌ ÁøÇàµÇ°ÚÁö¸¸,

¸¸¾à ³×¹øÂ° ½Â·üÀÌ ¼¼¹øÂ° ½Â·ü°ú µ¿ÀÏÇÏ´Ù¸é
$grade[4] = 3 °ú °°ÀÌ, ³×¹øÂ° ¼øÀ§($grade[4])¿¡µµ Àü¼øÀ§(3)ÀÇ °ªÀÌ ÀúÀåµÇ¾î¾ß ÇÕ´Ï´Ù.

À̰ÍÀ» ÄÚµùÇÏ¸é ´ë·« ´ÙÀ½°ú °°½À´Ï´Ù.


$no = 1;

while(...) { // ¹Ýº¹¹® ½ÃÀÛ
$ÇöÀç½Â·ü = ÇöÀç½Â·ü;
if($ÇöÀç½Â·ü == $½Â·ü) {
$grade[$no] = $grade[$no-1];
} else {
$grade[$no] = $no;
}
$½Â·ü = $ÇöÀç½Â·ü;
$no = $no+1;
} // ¹Ýº¹¹® ³¡

¹¹°¡ Á» ºüÁø °Í °°Áö¸¸, ÇÏ¿©Æ° ¼øÀ§¸¦ ¹è¿­¿¡ ÀúÀå½ÃŰ¸é¼­, ÀÌÀüÀÇ °ª°ú ºñ±³ÇØ¾ß ÇÏ´Â °ÍÀº ¸Â½À´Ï´Ù.
Çѹø ½ÃµµÇغ¸¼¼¿ä...
 2004/05/05 17:38:51    


no
subject
name
date
hit
*
689
  ÄÚ¸àÆ® ¹øÈ£ ºÒ·¯ ¿À´Â °Å... [2]

¹ÙÅõ
2003/06/02 7282 1665
688
  ´äº¯Çü°Ô½ÃÆÇ¿¡ ´ëÇØ¼­ Áú¹®..^^ [3]

À̰æÁø
2004/02/25 8571 1665
687
  output.txt°ªÀÌ ºñº£ ½ÇÇàó·³ ¾È... [1]

±èÁÖ¿µ
2004/04/29 8398 1667
686
  ºñÁÖ¾óº£ÀÌÁ÷°ú ¿À¶óŬ ¿¬µ¿¿¡¼­ Áú¹®ÀÔ... [1]

ÀÓ¼ºÈ¯
2003/05/05 8251 1668
685
  ¿¡·¯Á»ºÁÁÖ¼¼¿ä(¼ÒÄÏÅë½Å) [1]

±è´ëÇØ
2003/05/21 7490 1672
684
  ºñÁÖ¾ó º£ÀÌÁ÷6.0 1ºÎÅÍ100±îÁö ÇÕ... [1]

°í¼¼È­
2004/04/21 9917 1673
683
    [re] ÆäÀÌÁö¸µÅ©¶§¹®¿¡ ±Û¿Ã·È¾ú´Âµ¥¿©... [1]

¼Õº´¸ñ
2003/04/26 7392 1675
682
  ±âÃʼöÁØÀÇ Áú¹®.. ÀÌÁö¸¸ .. ²À ´äº¯ ... [2]

¸Ç¶¥ ÇØµù
2004/06/23 8282 1676
681
  °Ô½ÃÆÇ ÄÚµù½Ã $HTTP_POST_VARS ¼³... [1]

¹Ú¹Ì¼±
2004/11/02 8726 1678
680
  ºÎʵ右´Ï´Ù.. Á» ±ÞÇØ¼­.. [1]

Äھ˶ó
2003/05/07 7889 1679
679
      °¨»çÇÕ´Ï´Ù...±×·±µ¥..

Á¶Àμ÷
2002/08/10 7729 1682
678
  ±ÜÀû±ÜÀû Áú¹® Çϳª¸¸ ´õµå¸®°Ú¾¹´Ï´Ù. [4]

¿À¼®Áø
2004/03/21 7600 1683
677
  ´äº¯..»¡¸® ºÎÅ¹ÇØ¿ä..

À±Çö¹Ì
2002/09/28 7631 1684
676
    [re] °Ë»öÀ» select ÆûÀÌ ¾Æ´Ï¶ó üũ¹Ú... [1]

¼Õº´¸ñ
2003/06/07 8515 1684
675
  list.php¿¡¼­ ¸¶¿ì½º¿Àºê¶û¾Æ¿ì °ü·Ã [3]

»Ñ²Ù
2004/03/21 7895 1685
674
  °Ô½ÃÆÇ ÇÁ·ÎÁ§Æ® 1¿¡¼­ Áú¹®ÀÔ´Ï´Ù.

¹ÚÁ¤È£
2003/11/21 7758 1686
673
  ºñº£ Ãʺ¸ Áú¹®ÀÌ¿ä »¡¸® ´äÇØÁÖ½Ã¸é °¨... [2]

ºñº£ Á¤¸» Ãʺ¸
2004/03/31 8121 1687
672
    [re] Áú¹®]¿À¶óŬ¿¡¼­ db »èÁ¦¿¡ °üÇØ¼­ Áú...

Á¤¼ö¶ó
2003/07/04 7526 1689
671
  À¥¼­¹ö¿¡ °üÇÑ Áú¹®ÀÔ´Ï´Ù. [4]

ºÀÀÌ
2004/12/30 8555 1691
670
  ÀÚ·áÀԷ¶õ¿¡ ÀÔ·ÂÀ» ÇÏÁö ¾Ê°í ÀÔ·ÂÀ» ... [1]

xko
2003/11/07 7698 1693
[1][2][3][4][5][6][7] 8 [9][10]..[42] [next]

Copyright 1999-2025 Zeroboard / skin by Zetyx