20.09.2014, 05:25
hello how to top players with played time my mysql: Hour, Min, Sec
im got hour last but this is best time
http://imgur.com/2ti6lBw
paint work
PHP код:
<?php
$top = "100";
$val = "Hour";
$min = "Min";
$sec = "Sec";
$sql = mysql_query("SELECT * FROM `accounts` ORDER BY $val, $min DESC limit $top");
$kiek = 0;
echo "<h3>TOP 10 pagal praћaistą laiką</h3>";
echo "<table class=\"table table-bordered\">";
echo "<thead>";
echo "<tr>";
echo "<th>#</th>";
echo "<th>Vardas_Pavarde</th>";
echo "<th>Pinigai</th>";
echo "</tr>";
echo "</thead>";
while($row = mysql_fetch_array($sql))
{
$kiek++;
lentele3(topas3($kiek, $row['Fullname'], $row[$val], $row[$min]));
}
function lentele3($tops)
{
echo "<tbody>";
echo "<center>$tops</center>";
}
function topas3($vieta,$vardas,$skaicius0, $skaicius1)
{
echo "<tr>";
echo "<td>$vieta</td>";
echo "<td>$vardas</td>";
echo "<td>$skaicius0 val.</td><td> $skaicius1 min.</td>";
echo "</tr>";
}
echo "</tbody>";
echo "</table>";
?>
http://imgur.com/2ti6lBw
paint work