Sorting using array

bengt

Hello

I have this code to retreive data from MySql.

$sql = "SELECT * FROM vdeltakere WHERE brukerid = '".$u[id]."'";
$result = mysql_query($sql);
$vakter = array();
$i = 0;

//Lager en array som inneholder alle vaktid'er
while ($row = mysql_fetch_array($result)) {
	$tmpvakter = array($i => $row[vaktid]);
    $vakter = array_merge($vakter, $tmpvakter);
	$i++;

Create the output...

foreach($vakter as $vaktid) { 
	$sql = "SELECT *,DATE_FORMAT(fra, '%d/%m-%Y') as ffra,DATE_FORMAT(til, '%d/%m-%Y') as ttil FROM vakter WHERE id = '".$vaktid."' AND fra > now() LIMIT 1";
	$vakt = mysql_fetch_array(mysql_query($sql));
	if ($vakt[id]) {
		?>
		<tr class=list style="cursor:hand" onclick="location.href='<?=$php_self;?>?func=vakter&action=detaljer&id=<?=$vaktid;?>'"><td><?=$vakt[arrangement];?></td><td><?=$vakt[ffra];?></td><td><?=$vakt[ttil];?></td></tr>
		<?
	}
}

I would like to sort the output based on date from vakter .
Do you understand what I mean?

bogu

$sql = "SELECT vaktid FROM vdeltakere WHERE brukerid = '".$u[id]."' ORDER BY vaktid ASC"; 
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) 
	$vakter[] = $row['vaktid'];

/* now your $vakter array is sorted ASC */