PHP对循环的结果进行排序并在屏幕上显示

Question

I was wondering if someone could point me in the right direction with a coding issue Im having.

I am running a while loop in PHP comparing a post code to another and each run of the loop generates distance data. What Id like to do is then sort this data and display it.

Usually I'd throw everything into a MySQL database then sort that way but I think thats over kill.

Here's an example of the loop :

while($row = mysql_fetch_array($result))
{

    $info = get_driving_information($_POST['customerpostcode'], $row[instructor_postcode]); 

echo $row['instructor_name']  . " - " . $info['distance'];  
}

I know this is probably PHP 101 but Ive never had to do anything like this before and am not sure how.

Thanks in advance for reading,

Rik

Answer 1

I think this is what you mean:

$rows = array();
while($row = mysql_fetch_array($result))
{
    $info = get_driving_information($_POST['customerpostcode'], $row[instructor_postcode]); 
    $row['distance'] = $info['distance']; // store it in the array

    $rows[] = $row;
}

Then use usort to sort the $rows array by the distance key.