help with array sorting

anakadote

hi. i'm trying to sort an array by the dates at the beginning of each value. ive tried nat_sort which seems to be the most logical choice but it does not work. any suggestions?

when i print_r my array this is what i get:

Array ( [0] => 2005-07-14,Admin updates- fixes,4.5,taylor [1] => 2005-07-13,Admin updates,5,taylor [2] => 2005-07-13,Room planner updates,4.5,Rich [3] => 2005-07-13,News section revisions,2,Rich [4] => 2005-07-13,Typing copy,0.3,Sarah [5] => 2005-07-12,News section revisions,1,Rich [6] => 2005-07-12,Room planner updates,1,Rich [7] => 2005-05-31,PHP.MySQL- Hildi Videos- Hildi Printable Pages,4,Taylor [8] => 2005-05-31,Ask Hildi,1,Rich [9] => 2005-05-30,Room Planner,6.50,Rich [10] => 2005-05-29,Room Planner,2,Rich [11] => 2005-05-28,Room Planner,3,Rich [12] => 2005-05-27,Room Planner,7,Rich [13] => 2005-05-26,Room Planner and Ask Hildi,7,Rich [14] => 2005-05-25,Room Planner and Ask Hildi,7,Rich [15] => 2005-05-24,Room Planner,1,Rich [16] => 2005-05-23,Ask Hildi,0.50,Rich [17] => 2005-05-13,Room Planner,5,Rich [18] => 2005-05-12,Room Planner,9,Rich [19] => 2005-05-10,Room Planner/News/Mini Headlines,6,Rich [20] => 2005-07-12,Web site updates,2.50,Rob )

RossC0

Might be easier to split your comma delimited array then run a sort..

anakadote

im not sure how that would work. if there is a way to sort the main array, that would be the most practical. when i use natcasesort() it print_r just a 1. and then the foreach loop fails.

here's my code:

if($row['timeSheet'] != ''){
$array = explode('|', rtrim($row['timeSheet'], '|'));

$array = natcasesort($array);
print_r($array);


foreach($array as $each){ 
	$info = explode(',', $each);
	$formatted=date('F d, Y', strtotime($info[0]));

		echo'<tr>
        <td valign="top" class="bodycopy">' . $formatted . '</td>
       <td colspan="2" valign="top" class="bodycopy">' . $info[1] . '</td>
       <td valign="top" class="bodycopy">' . ucwords($info[3]) . '</td>
	   <td valign="top" class="bodycopy">' . $info[2] . '</td>
        </tr>';

	}

}

Weedpacket

[man]usort[/man] is your friend. Have a look at it. (Also, note that ISO-formatted date strings like you have will sort() in the normal fashion without needing any sort of "natsort" carryon. Which is one reason why the format is used.)