multisort array

_angel_

Hi,

Can someone please put me out of my misery and tell me why this will sort by $user_total_posts:

$top_posters[] = array('user_id' => 1, 'user_total_posts' => 993);
$top_posters[] = array('user_id' => 2, 'user_total_posts' => 209);
$top_posters[] = array('user_id' => 3, 'user_total_posts' => 2);
$top_posters[] = array('user_id' => 4, 'user_total_posts' => 4);
$top_posters[] = array('user_id' => 5, 'user_total_posts' => 90);
$top_posters[] = array('user_id' => 6, 'user_total_posts' => 25);

foreach ($top_posters as $key => $value) 
{
   $user_id[$key]  = $value['user_id'];
   $user_total_posts[$key] = $value['user_total_posts'];
}

array_multisort($user_total_posts, SORT_DESC, $user_id, SORT_ASC, $top_posters);

print_r($top_posters);

but this wont:

    $SQL     = "SELECT * FROM " . USERS_TABLE . "";
    $results = ExeSQL($SQL);

while ($row = mysql_fetch_array($results)) 
{
	$user_id = $row["user_id"];
	$user_total_posts = user_total_posts(&$user_id);
	$top_posters[] = array('user_id' => $user_id, 'user_total_posts' => $user_total_posts);
}

foreach ($top_posters as $key => $value) 
{
   $user_id[$key]  = $value['user_id'];
   $user_total_posts[$key] = $value['user_total_posts'];
}

array_multisort($user_total_posts, SORT_DESC, $user_id, SORT_ASC, $top_posters);

print_r($top_posters);

Thanks

devinemke

i think you are way overcomplicating this. what are you trying to do here? sort by user_total_posts? if so then just do that at the query:

SELECT * FROM table ORDER BY user_total_posts

_angel_

Hey,

Thanks for your reply 🙂

Unfortunately i can't do that because i don't have a user_total_posts field in my table. $user_total_posts is worked out by passing the user_id through the user_total_posts() function.

	$user_total_posts = user_total_posts(&$user_id);

What i need it to do is take the user_id from the table, work out the $user_total_posts and then put those (along with a few other details from the table) in an array which is sorted by $user_total_posts.

What i have currently got is an array which will not sort at all! :mad:

I have tried other ways of doing it but they didn't work either 🙁

Any ideas?

thorpe

You still should be able to do it in your query. What does your table structure look like, and what data do you want pulled?

devinemke

what does user_total_posts() do? show the code.

_angel_

thorpe wrote:
You still should be able to do it in your query. What does your table structure look like, and what data do you want pulled?

Hi thorpe,

Thanks for replying 🙂

ATM im just trying to pull the user_id so i can put it in an array with the $user_total_posts. If i can get that to work i should have no problems modifying it to pull any other fields i need e.g. user_username etc.

I am currently testing this using a table with just the user_id and user_username fields. The structure for this is as follows:

CREATE TABLE `users` (
  `user_id` int(10) NOT NULL auto_increment,
  `user_username` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

_angel_

devinemke wrote:
what does user_total_posts() do? show the code.

I have just tried replacing $user_total_posts etc. with another field from the table (user_username) and i can't get that to work either. Again it pulls the data ok but will not sort the array.

So i guess user_total_posts() can't be the prob 🙁