Code: Select all
$result = mysql_query("SELECT * FROM `characters` ORDER BY `character_id` ASC",$connect);
while($myrow = mysql_fetch_assoc($result)) {
echo "<table width='500' class='toutborder' cellspacing='2' cellpadding='2'><tr width='100%' class='titlegreen'>";
echo "<div align='center'><td class='titlered' align='center' width='25%'><b>Character:</b> <a href='/vpn/lookup.php?account_id=" . $myrow['account_id'] . "' class='link'>";
echo $myrow['character_name'];
echo "</a></td></div>";
echo "<div align='center'><td class='titlered' align='center' width='25%'><b>Last login:</b> ";
$result_acc = mysql_query("SELECT * FROM `accounts` WHERE `account_id`='" . $myrow['account_id'] . "' ",$connect);
$myrow_acc = mysql_fetch_assoc($result_acc);
if($myrow_acc['lastlogin']=='0000-00-00 00:00:00') {
echo "No data.";
}
else {
echo $myrow_acc['lastlogin'];
}
echo "</td></div>";
$get_p = mysql_query("SELECT SUM(ach_points) AS ach_points FROM `vpn_have` WHERE `character_id`='" . $myrow['character_id'] . "'",$connect);
$total = mysql_fetch_assoc($get_p);
$ach_points = $total['ach_points'];
echo "<div align='center'><td class='titlered' align='center' width='25%'><b>Points: </b>";
if($ach_points==0) {
echo "No data.";
}
else {
echo $ach_points;
}
echo "</td></div>";
echo "<div align='center'><td class='titlered' align='center' width='25%'><b>Achievements:</b> ";
$get_count = mysql_query("SELECT `achievement_id` FROM `vpn_have` WHERE `character_id`='" . $myrow['character_id'] . "' ",$connect);
$ach_count = mysql_num_rows($get_count);
echo $ach_count;
echo "</td></div>";
echo "</tr></table>";
}Question: How to order results by points? At the begin I tough I could use join function and join result $result with $get_p, but I failed joining them even looking from manual. Or maybe there is some other way how to order results by points?