0
 829   42   8
  View Articles

Name  
   ¿À¼®Áø  (2004-04-27 13:00:14, Hit : 7048, Vote : 1259)
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
  Äõ¸®¿¡ ´ëÇÏ¿©

±èÇö¼÷
2002/08/13 6535 1234
688
  [»ç¹«ÀÚµ¿È­]¿¢¼¼½º-Áú¹®ÀÔ´Ï´Ù. [1]

À¯Á¾¿ø
2003/09/19 7188 1234
687
  ±âÃʼöÁØÀÇ Áú¹®.. ÀÌÁö¸¸ .. ²À ´äº¯ ... [2]

¸Ç¶¥ ÇØµù
2004/06/23 7144 1234
686
  ±¤°í¼º ±Û ¹æÁö ÆÁ¿¡ ´ëÇØ¼­ Áú¹®ÀÌ¿ä [9]

À̱¹Áø
2004/10/24 7281 1234
685
  ½ÃÇèÀÚ°Ý

´ëÇѹα¹
2002/07/22 6601 1235
684
  [Áú¹®] ºó°ø°£Àִ ǥ ä¿ö³Ö´Â¹ý... [2]

Çȼ¿ÀÌ
2003/07/23 6311 1235
683
  ¤¸ ¤Ã¤¡ ¤Ó ¤· ¤Å

¼Ò¿µ
2002/08/03 6493 1237
682
  Q ºñº£Áú¹® ¿©·¯ °¡Áö

±èb
2002/07/25 6979 1239
681
  [jsp] ÅèĹ¹öÁ¯ÀÌ...? [1]

½Åâ¿ø
2004/01/10 7011 1240
680
  PHP °Ô½ÃÆÇ ¸¸µé±â list.php Áß¿¡

Ziwoogae
2003/01/07 7546 1243
679
  ºñÁÖ¾ó º£ÀÌÁ÷ µÎ¹øÂ°·Î Áú¹® µå¸°°Å¿© ... [1]

°í¼¼È­
2004/04/22 6931 1245
678
  ¿¡°í ¶Ç Áú¹®ÀÌ¿ä-- [1]

¹ÙÅõ
2003/05/28 6331 1246
677
  °Ô½ÃÆÇÀ» ¸¸µå´Â °úÁ¤¿¡ À־ÀÇ ÇѰ¡Áö... [3]

++web dang++
2003/06/24 7613 1246
676
  PHP°Ô½ÃÆÇ ÀνºÅçÀº... [2]

±èÁ¤ÀÎ
2003/11/08 6514 1246
675
  ¾È³çÇϼ¼¿ä. ¶Ç ÀÌÁ¤ÈÆÀÔ´Ï´Ù. [2]

ÀÌÁ¤ÈÆ
2004/09/06 7188 1247
674
  ÀÌ°Ç ¹¹¿¡ ¾²´Â°Å¿¡¿ä? [1]

¹ÙÅõ
2003/05/21 6424 1248
673
  PHP ÀÔ·ÂÆûÀ»¿ä... [1]

±èÁ¤ÀÎ
2003/11/10 7120 1248
672
      °¨»çÇÕ´Ï´Ù...±×·±µ¥..

Á¶Àμ÷
2002/08/10 6594 1253
671
  387¹ø¿¡ ´ëÇÑ ´äº¯ÀÌ ¾ø¾î¼­.. [3]

¹Ú»óÀº
2003/07/13 6508 1253
670
  ´äº¯Çü°Ô½ÃÆÇ¿¡ ´ëÇØ¼­ Áú¹®..^^ [3]

À̰æÁø
2004/02/25 7442 1253
[1][2][3][4][5][6][7] 8 [9][10]..[42] [next]

Copyright 1999-2021 Zeroboard / skin by Zetyx