rendered paste body<html><head><title>Doctor Who - Flag Stats</title></head><body><?phpinclude('adodb/adodb.inc.php');include('config.php');//Connect to dbglobal $data;$db = ADONewConnection($data['driver']); # eg. 'mysql' or 'oci8' $db->Connect($data['server'], $data['user'], $data['password'], $data['database']);?><table border="1"><tr><td><b>Name</b></td><td><b>Picked-Up (<a href="stat_flags.php?sortby=pickup&sort=ASC">ASC</a>/<a href="stat_flags.php?sortby=pickup&sort=DESC">DESC</a>)</b></td><td><b>Picked Up Percentage</b></td></tr><?php$total_flagpick = 0;$sort_by = $_GET['sortby'];$sort = $_GET['sort'];if ($sort_by == "pickup") { $sort_by = "Grabbed"; }if ($sort_by != "Grabbed") { $sort_by = "Grabbed"; }if ($sort != "ASC" && $sort != "DESC") { $sort = "DESC"; }$rs = $db->Execute("SELECT * FROM `Flags` ORDER BY `".$sort_by."` ".strtoupper($sort)."");if ($rs){ /*while ($arr = $rs->FetchRow()) { $total_flagpick += $arr['Grabbed']; }*/ while ($arr = $rs->FetchRow()) { echo "<tr>\n"; echo "<td>".$arr['Name']."</td>\n"; echo "<td>".$arr['Grabbed']."</td>\n"; echo "<td>",$arr['Grabbed']/$total_flagpick,"</td>\n"; echo "</tr>\n\n"; }}?><tr><td><b>Totals</b></td><?phpecho "<td>",number_format($total_flagpick),"</td>\n";echo "<td></td>\n";?></tr></table><?php$db->close();?></body></html>