Sorting an multidimensional array

Question

macneato 29 Posting Pro in Training

15 Years Ago

Hi, so im pulling arrays from facebook. But i would like to sort them.

Here is how the arrays look

Then i display them using the following

// check the result is loop-able
if (is_array($events) && !empty($events)) {
	
	$events = array_slice($events, 0,5);
	
	foreach ($events as $event) {
		
	echo "<fb:tag name='div'><fb:tag-attribute name='class'>event_image</fb:tag-attribute>
			<fb:tag-body>
				<fb:tag name='img'><fb:tag-attribute name='src'>".$event["pic"]."</fb:tag-attribute></fb:tag>
			</fb:tag-body>	
		  </fb:tag>";
	// Right Container
	echo "<fb:tag name='div'><fb:tag-attribute name='class'>event_details</fb:tag-attribute>
			<fb:tag-body>";
	echo "<fb:eventlink eid=".$event["eid"]." /><br/>";
	echo "<fb:tag name='div'><fb:tag-attribute name='class'>text_standout</fb:tag-attribute> 
			<fb:tag-body> 
				<fb:tag name='div'><fb:tag-attribute name='class'>txt_event_heading</fb:tag-attribute>
					<fb:tag-body> 
						Type:
					</fb:tag-body>
				</fb:tag>  
				".$event["event_type"].
			"</fb:tag-body>
		  </fb:tag>";
	echo "<fb:tag name='div'><fb:tag-attribute name='class'>text_standout</fb:tag-attribute> 
			<fb:tag-body> 
				<fb:tag name='div'><fb:tag-attribute name='class'>txt_event_heading</fb:tag-attribute>
					<fb:tag-body> 
						When:
					</fb:tag-body>
				</fb:tag>
		  <fb:date t='".$event["start_time"]."' format='monthname_time' tz='GMT+2' /></fb:tag-body></fb:tag>";
	echo "<fb:tag name='div'><fb:tag-attribute name='class'>text_standout</fb:tag-attribute> 
			<fb:tag-body> 
				<fb:tag name='div'><fb:tag-attribute name='class'>txt_event_heading</fb:tag-attribute>
					<fb:tag-body> 
						Location:
					</fb:tag-body>
				</fb:tag> "
		  .$event["location"]."</fb:tag-body></fb:tag>";
	echo "<fb:tag name='div'><fb:tag-attribute name='class'>text_standout</fb:tag-attribute> 
		<fb:tag-body> 
				<fb:tag name='div'><fb:tag-attribute name='class'>txt_event_heading</fb:tag-attribute>
					<fb:tag-body> 
						Description:
					</fb:tag-body>
				</fb:tag> "
	  .$event["description"]."</fb:tag-body>
	  </fb:tag>";
	echo "</fb:tag-body></fb:tag>";
		
	} // foreach

} // if

Heres my issue. I would like to sort the arrays by ["start_time"], so that when i display them, they are in order from soonest to latest.

Any help would be seriously appreciated. Thanks in advance.

php

3 Contributors
3 Replies
202 Views
1 Day Discussion Span
Latest Post 15 Years Ago Latest Post by macneato

network18 15 Practically a Master Poster

15 Years Ago

use array_multisort($targetArray,SORT_ASC)

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

deonheunis 0 Newbie Poster · Answer 1 · 2009-10-23T12:16:15+00:00

function multi_sort($tab,$key){
    $compare = create_function('$a,$b','if ($a["'.$key.'"] == $b["'.$key.'"]) {return 0;}else {return ($a["'.$key.'"] > $b["'.$key.'"]) ? -1 : 1;}');
    usort($tab,$compare) ;
    return $tab ;
}

This will do the job for you

macneato 29 Posting Pro in Training · Answer 2 · 2009-10-23T13:16:54+00:00

Hi Deon,

Thanks for your help. Ending up going with the following, that works quite well

// Get event arrays
$today = time();
$events = $facebook->api_client->events_get('138907126863','','$today','','');

// Sort arrays
	//Function used to sort array
	function csort($array, $column) {
		$s = array();
		foreach($array as $row) {
			$s[] = $row[$column];
		}
		array_multisort($s, SORT_ASC, SORT_NUMERIC, $array);
	return $array;
	}
$events_sorted = csort($events, 'start_time');	

// Slice sorted arrays
$events_slice = array_slice($events_sorted, 0, 1);																						

// Used the sorted arrays to echo data

foreach ($events_slice as $event) {
	echo time();
	echo "<fb:tag name='div'><fb:tag-attribute name='class'>event_image</fb:tag-attribute>
			<fb:tag-body>
				<fb:tag name='img'><fb:tag-attribute name='src'>".$event["pic"]."</fb:tag-attribute></fb:tag>
			</fb:tag-body>	
		  </fb:tag>";
	echo "<fb:tag name='div'><fb:tag-attribute name='class'>event_details</fb:tag-attribute>
			<fb:tag-body>";
	echo "<fb:eventlink eid=".$event["eid"]." /><br/>";
	echo "<fb:tag name='div'><fb:tag-attribute name='class'>text_standout</fb:tag-attribute> 
			<fb:tag-body> 
				<fb:tag name='div'><fb:tag-attribute name='class'>txt_event_heading</fb:tag-attribute>
					<fb:tag-body> 
						When:
					</fb:tag-body>
				</fb:tag>
		  <fb:date t='".$event["start_time"]."' format='monthname_time' tz='GMT+2' /></fb:tag-body></fb:tag>";
														
}