How do I sort my mySQL table?

[w33nie]

I want to sort the following table, that contains this data, in a .php page I'll use on my website.

I want to sort it by a few columns too, I want it to sort by points, then difference, then for.

The following is the code I have in my .php file.

<? $hostname = "***.secureserver.net"; // The mySQL DB server. 
$username = "acssl_table"; // The username you created for this database. 
$password = "Victoria3"; // The password you created for the username. 
$usertable = "table"; // The name of the table you made. 
$dbName = "acssl_table"; // This is the name of the database you made. 
 
MYSQL_CONNECT($hostname, $username, $password) OR DIE("DB connection unavailable");
@mysql_select_db( "$dbName") or die( "Unable to select database"); 
?> 
<? 
//error message (not found message)begins 
$XX = "No Record Found, to search again please close this window"; 
//query details table begins
$query = mysql_query("SELECT * FROM `table` LIMIT 0, 30 "); 
while ($row = @mysql_fetch_array($query)) 
{ 
$variable1=$row["team"];
$variable2=$row["played"]; 
$variable3=$row["won"]; 
$variable4=$row["drawn"];
$variable5=$row["lost"];
$variable6=$row["for"]; 
$variable7=$row["against"]; 
$variable8=$row["difference"]; 
$variable9=$row["points"];
//table layout for results 
 
print ("<tr>");
print ("<td width='150'><span class='BodyTable'>$variable1</span></td>");
print ("<td width='50' align='center'><span class='BodyTable'>$variable2</span></td>");
print ("<td width='50' align='center'><span class='BodyTable'>$variable3</span></td>");
print ("<td width='50' align='center'><span class='BodyTable'>$variable4</span></td>");
print ("<td width='50' align='center'><span class='BodyTable'>$variable5</span></td>");
print ("<td width='50' align='center'><span class='BodyTable'>$variable6</span></td>");
print ("<td width='50' align='center'><span class='BodyTable'>$variable7</span></td>");
print ("<td width='75' align='center'><span class='BodyTable'>$variable8</span></td>");
print ("<td width='75' align='center'><span class='BodyTable'>$variable9</span></td>");
print ("</tr>"); 
}
//below this is the function for no record!!
if (!$variable1)
{ 
print ("$XX");
} 
//end 
?>

[Motoma]

The images did not work for me.
I would suggest, however, that you use a simple ORDER BY clause when doing your SELECT:

$query = mysql_query("SELECT * FROM `table` ORDER BY points DESC, difference ASC, for ASC LIMIT 0, 30 "); 
 

[w33nie]

thanks, but that doesn't completely work..
it'll only let me sort it by the Points and Difference. Whenever I try to sort using for, the entire table crashes.
why?

Even if I'm sorting by For on its own, it crashes the table.

[w33nie]

heres another screenshot of the data, hopefully this one will work.

but i doubt the problem is in the actual database

[ronverdonk]

thanks, but that doesn't completely work..
it'll only let me sort it by the Points and Difference. Whenever I try to sort using for, the entire table crashes.
why?

Even if I'm sorting by For on its own, it crashes the table.

Of course it sorts by Point and Difference only. That is what has been specified in the SELECT statement. For other columns, you just have to change the SELECT statement's ORDER BY sequence to get another order for other column(s).

So, when you want to sort on 'For' you issue the statement

$query = mysql_query("SELECT * FROM `table` ORDER BY for ASC LIMIT 0, 30 ");  

Ronald :cool: