Order by php-variable

[Postman]

I have the code as show below to collect variables from a mysql-database as well as create some variables in php using database collected variables to calculate from. I want to order the table 1) $point 2) $diff 3) $plus. Can I do this directly in PHP? If yes, how? If not, can I create columns in the mysql-database that automaticly updates when a relating column is being updated? (ie if I increase the column named won with 1 the (new) column tot_points is set to ((win3)+(draw1)). Is it possible to use a recursive function fix this problem in PHP? (If yes, what would that function look like?)

$query = "SELECT * FROM $table1 WHERE league='$league'";
	$result=mysql_query($query);
	$num=mysql_numrows($result);


echo "<table border=0><tr><td width=150>Lag</td><td width=20>S</td><td width=20>V</td><td width=20>O</td><td width=20>F</td><td width=20 align=center>+</td><td width=20 align=center>-</td><td width=20 align=center>+/-</td><td width=20 align=center>P</td></tr>";
for ($counter=0;$counter<$num;$counter++)
{
	$team[$counter+1]=mysql_result($result,$counter,'team');
	$won[$counter+1]=mysql_result($result,$counter,'won');
	$draw[$counter+1]=mysql_result($result,$counter,'draw');
	$lost[$counter+1]=mysql_result($result,$counter,'lost');
	$played[$counter+1]=$won[$counter+1]+$draw[$counter+1]+$lost[$counter+1];
	$plus[$counter+1]=mysql_result($result,$counter,'plus');
	$minus[$counter+1]=mysql_result($result,$counter,'minus');
	$diff[$counter+1]=$plus[$counter+1]-$minus[$counter+1];
	$point[$counter+1]=$won[$counter+1]*3+$draw[$counter+1]*1;

	echo "<tr><td>",$team[$counter+1],"</td><td>",$played[$counter+1],"</td><td>",$won[$counter+1],"</td><td>",$draw[$counter+1],"</td><td>",$lost[$counter+1],"</td><td align=right>",$plus[$counter+1],"</td><td align=right>",$minus[$counter+1],"</td><td align=right>",$diff[$counter+1],"</td><td align=right>",$point[$counter+1],"</td></tr>";
}

echo "</table>";

[uffis]

You could use triggers to update the total points, but in general, the database shouldn't store data that can be derived from other data. What that means is you should do the math with a query, i.e. SQL function SUM.

The ordering should be done with the query, as well, and not in PHP.

Also, are you aware that it would be more efficient to use mysql_fetch_row than mysql_result?

And you can use arrays in PHP without using an index counter:

$team = array();

$team[] = 'foo';
$team[] = 'bar';

[Weedpacket]

Have a look at [man]mysql_fetch_array[/man] instead of piles of mysql_request() calls. Also, you can control the order in which fields are returned in the resulting array simply by naming them in the query (which also improves query efficiency):

SELECT team,won,draw,lost,[i]etc.[/i]  FROM...

It's usually more convenient to keep the returned result data in a single array variable, but if you do want lots of individual variables, look at [man]list[/man] or [man]extract[/man]. But then there is no meaning to "order of variables".

[Postman]

it was much easier then I thought. I just changed the query from

$query = "SELECT * FROM $table1 WHERE league='$league'";

to

	$query = "SELECT * FROM $table1 WHERE league='$league' ORDER BY won*3+draw*1 DESC";

and I got exactly the result I was looking for....