Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. $result = mysql_query( "select SUM(achievenum) as achieve_rows from games" );
  2. $row = mysql_fetch_object( $result );
  3. $total_achieve = $row->achieve_rows;
  4.  
  5. $result = mysql_query( "select SUM(achieveget) as get_rows from games" );
  6. $row = mysql_fetch_object( $result );
  7. $get_achieve = $row->get_rows;
  8.  
  9. $completed_rate = $get_achieve * 100 / $total_achieve;
  10.  
  11. Completion Rate : 32.3529411765%
  12.  
  13. 32.3 %
  14.  
  15. select
  16. SUM(achievenum) as achieve_rows,
  17. select SUM(achievenum) as achieve_rows
  18. from games
  19.  
  20. <?php
  21. echo round($completed_rate,1)."%";
  22. ?>
  23.  
  24. select ROUND(SUM(achieveget)*100/SUM(achievenum),1) as completion_rate from games
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement