php sort help required please :)

[CavemanUK]

Hi,

i hope i can explain this correctly.. I am making a page that creates a 3d pie chart for the different types of calls my work has. I have a MySQL database that has jobs and referrers.. Anyway thats not imporant.. what I need to pass to the pie chart is the top 10 best referrals. The two bits of data for each record i have are...

$referrer[] (pulled from a Jobs table in my database)
$referrercount[] (a count of all jobs for that referrer query)..

I know php has a sort feature but i need the 2 variables to stay in sync. I know i need to use a 2 dimensional array but I really am struggling to understand them. can someone give me a code example using the following data...

$referrer[0] = "Company A"
$referrercount [0] = 300

$referrer[1] = "Company B"
$referrercount [1] = 500

$referrer[2] = "Company C"
$referrercount [2] = 100




I hope this makes sense..?

 

[elppa]

See: http://www.php.net/manual/en/array.sorting.php

<?php
	$referrer[0] = "Company A";
	$referrercount[0] = 300;

	$referrer[1] = "Company B";
	$referrercount[1] = 500;

	$referrer[2] = "Company C";
	$referrercount[2] = 100;
	
	// sort high to low, maintain indices
	arsort($referrercount);
	foreach($referrercount as $key => $value) {
		echo "{$referrer[$key]}: {$referrercount[$key]}".PHP_EOL;
	}
?>

Prints:

Company B: 500
Company A: 300
Company C: 100

Hope I have understood and that is what you are after?

 

[Darth.Titan]

Sounds to me like you'd be better off doing your sorting in your sql query and only pulling the relevant results with something like:

...
ORDER BY COUNT(referrer) DESC
LIMIT 10

Not knowing your table schema that's about as specific as I can get.

 

[CavemanUK]

Sounds to me like you'd be better off doing your sorting in your sql query and only pulling the relevant results with something like:

...
ORDER BY COUNT(referrer) DESC
LIMIT 10

Not knowing your table schema that's about as specific as I can get.

Thanks guys for your replies.. going to try the code suggestion now... i cant do it with a query as one of the variables is the result of a record count rather than a field itself...

 

[CavemanUK]

elppa's suggestion worked a treat. thanks guys.