Jump to content

Sorting Problem??


Skipjackrick

Recommended Posts

hello again fellas.

 

So, I am trying to make a standings page which will rank every team by the amount of points they have acquired.  I figured out how to sum up the total points but I want to sort the points from Highest to Lowest and keep the (team/points) relationship together.  Could you guys help out a Noobie!?!

 

 

If you have any ideas on how I can populate the Rank column with First, Second, and third etc. that would help out too.  But one step at a time.

 

 

Thanks AGAIN!!!  You guys always help out!!

 

 

$query_sum = "SELECT 
		team_id,
	SUM(points) 
	FROM submit 
	GROUP BY team_id"; 
$result = mysql_query($query_sum) or die(mysql_error());

$kayakwars_header=<<<EOD
<h2><Center>Kayak Wars 2008 Standings</center></h2>
<table width='70%' border='1' cellpadding='2' cellspacing='2' align='center'>
<tr>
	<th>Rank</th>
	<th>Team</th>
	<th>Points</th>
</tr>
EOD;
function get_team_name() {
global $team_id;
global $teamname;

$query_d = "SELECT team_name
	FROM team
	WHERE team_id='$team_id'";
$results_d = mysql_query($query_d) or die(mysql_error());
$row_d = mysql_fetch_array($results_d);
extract ($row_d);
$teamname = $team_name;
}
while($row = mysql_fetch_array($result))
{
$team_id = $row['team_id'];
$points = $row['SUM(points)'];

//get team's name from team table
get_team_name($team_id);

$kayakwars_details .=<<<EOD
<tr>
	<td>First</td>
	<td>$teamname</td>
	<td>$points</td>
</tr>
EOD;
}



$kayakwars_footer ="</table>";

$kayak_wars =<<<KAYAKWARS
	$kayakwars_header
	$kayakwars_footer
KAYAKWARS;

print "There are $num_entries Kayak Wars submissions in our database";
print $kayak_wars;

Link to comment
Share on other sites

$x=1;
while($row = mysql_fetch_array($result))
{

 

<td>$x</td>

 

EOD;
$x++;
}

 

would produce something like

 

<tr><td>1</td><td>team</td><td>points</td></tr>
<tr><td>2</td><td>team</td><td>points</td></tr>
<tr><td>3</td><td>team</td><td>points</td></tr>

 

etcetera

Link to comment
Share on other sites

$x=1;
while($row = mysql_fetch_array($result))
{

 

<td>$x</td>

 

EOD;
$x++;
}

 

would produce something like

 

<tr><td>1</td><td>team</td><td>points</td></tr>
<tr><td>2</td><td>team</td><td>points</td></tr>
<tr><td>3</td><td>team</td><td>points</td></tr>

 

etcetera

 

Cool (one down), but how do I sort the Points from Highest to Lowest?

Link to comment
Share on other sites

you have

 

SUM(points) 

 

make it

 

SUM(points) as total_points

 

then after

 

FROM submit

 

add

 

ORDER BY total_points DESC

 

I Tried that and for some reason it doesn't return any data from the database.  I think its trying to GROUP BY team and then we are telling it to ORDER by total_points which contradicts the GROUP BY statement.

 

I am clueless.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.