Multidimensional array help request?

[integer99]

Hi all

To put you in the picture, I'm trying to create a championship points table for a local kart racing club, by pulling the drivers name and points from an unknown number of tables. The table setup is kinda weird - each table has one race meetings results in (which consists of approx 4 races for each driver). In short, I need to check all the tables, get one instance of each drivers name, then get the points for that driver (of which there will be about 4 entries per table) and add them up to create a total points sum.

Heres what I have so far:

<?

include ("config.php");

$result = mysql_list_tables("$db");
$i = 0 ;

while ($i < mysql_num_rows ($result))
{
	$tb_names[$i] = mysql_tablename($result, $i);
	$getnames = mysql_query("select name from $tb_names[$i] group by name");

while ($gotnames = mysql_fetch_array($getnames))
{
	$total = 0;
	$name = $gotnames['name'];

	$getpoints = mysql_query("select points from $tb_names[$i] where name = '$name'") or die(mysql_error());
	while ($gotpoints = mysql_fetch_array($getpoints))
	{
		$points = $gotpoints['points'];
		$total += $points;
	}

	echo "$name has $total points<br>";

}
$i++;
}

?>

This gives me all the info I want, but I can't figure out how to put it in order (by points total). I'm guessing I'll need to put it all in a multi-dimesional array and then sort it but I'm not having much luck getting my head round it.

Any help would be greatly appreciated..

[dalecosp]

Well, you'd start here:

 echo "$name has $total points<br>";

I'd probably get the ball rolling with

$drivers=array();  

// that line up top somewhere

//and then where you have the echo, have instead

$drivers[$i]="$name | $total_points";

Then, later on, (if I'm understanding the nature of your data) you're gonna have to loop through the "$drivers" array and compare the first string elements of each entry to see if the same driver is listed; if so, grab the second part of the string and add it to some temp var while your total his points for the season, etc.

Can you tell I've the hacker nature? "Just start coding and work out the details later ... " 😃

[integer99]

Thanks - i'll have a play....