Sorting script

[civic]

I am having trouble on where to put in a code to have this sort by $activerecruits... any help?

	function recruiters() {		

	global $skin, $members, $db;



	$users = $members->fetch_rows();
	$data = '';

	foreach($users as $user) {

		$total_recruits = $db->result($db->query('SELECT COUNT(*) FROM `members` WHERE `recruiter` = "' . $user['id'] . '"'));
		$active_recruits = $db->result($db->query('SELECT COUNT(*) FROM `members` WHERE `recruiter` = "' . $user['id'] . '" AND `status` <> (`status` | 64 )'));

		$ratio = $active_recruits / $total_recruits;

		if($total_recruits > 0 and $ratio > 0) {

			$total_recruits = number_format($total_recruits, 0, '.', ',') . '%';
			$active_recruits = number_format($active_recruits, 0, '.', ',');
			$ratio = number_format($ratio * 100, 2, '.', ',');

			$data .= '<tr><td class="normal">' . $members->link($user['id']) . '</td><td class="normal">' . $total_recruits . '</td><td class="normal">' . $active_recruits . '</td><td class="normal">' . $ratio . '</td></tr>';

		}

	}

	return $skin->form_start('Top Recruiters') .
	'<table style="width:400px"><tr><td class="normal"><b>Member</b></td><td class="normal"><b>Total Recruits</b></td><td class="normal">Active Recruits</td><td class="normal">Percentage Active</td></tr>'
	. $data		
	. '</table>' . $skin->form_end();

}

Thanks!

[NogDog]

Presumably you could add an "ORDER BY" clause to the $active_recruits query?

[civic]

That doesn't work.

[leatherback]

civic wrote:

That doesn't work.

How have yu tried this, and what does it give you?

[civic]

Gives me the same EXACT thing as it does without it.

[laserlight]

What exactly did you try?