Group Array?

[lmayer4]

Afternoon,

I'm almost there. Except I want it to group by one field first then by another.

Right now it groups by classification. I want it to group by Status first THEN classification. Can anyone point me in the right direction?

Thanks so much.

    <?
    include("UpLoad/connect.php");
    //load it all into the associative array
    $sql = "SELECT Classification,
                case when status = 'Off Rent' then 'Do Not Use'
                else Status end as Status,
            TrailerID,Specialty,CargoType,BodyType,Length,Do
    orType,OwnershipType,Description,
            Location,Contents,Comments,UpLoadTime    

            from Yardcheck.dbo.vwCountDailyYC
            where Source = 'North Hatfield'
            and UpLoadDate= '04/28/2005'
            and AMPM='AM'
            order by CargoType,Length DESC";
    $result = mssql_query($sql);
    echo "<center>Daily AM Yard Check--- North Hatfield<p>";
    echo date("l") ;
    echo "---";
    echo date("m/d/Y") ."</center>";
    echo "<table border='1'>";
    while($row = mssql_fetch_row($result)) 
        {
        $total = mssql_num_rows($result);
        $myArray[$row[0]] = $row[1];
        //now we expand it
        while(list($Classification,$Status) = each($myArray)) 
            {
            echo "<tr><th colspan=4><b>$Classification Trailers</b></td></tr>";
                } 
                echo "<tr>";
                echo "<td>$row[1]</td>";
                echo "<td>$row[2]</td>";
                echo "<td>$row[3]</td>";
                echo "<td>$row[4]</td>";
                echo "<td>$row[5]</td>";
                echo "<td>$row[6]</td>";
                echo "<td>$row[7]</td>";
                echo "<td>$row[8]</td>";
                echo "<td>$row[9]</td>";
                echo "<td>$row[10]</td>";
                echo "<td>$row[11]</td>"; 
                echo "<td>$row[12]</td>";
                echo "<td>$row[13]</td>";
                echo "</tr>";
            }
    echo "</table>";
    echo "Total Trailers: ". mssql_num_rows($result);
    ?>

[Weedpacket]

There are a number of sorting functions in PHP; but you should be able to do it in the query - which, as far as I can see, sorts by CargoType and then by Length.

[lmayer4]

I guess I should be clearer.

Right now it groups like this:

Wood Trailers
trailer# 123333 status active
trailer# 123456 status do not use
next trailer and so on

What I would like to see is something like this:

Wood trailers
trailer# 123333 status active
trailer# 256899 status active

Wood Trailers
trailer# 123456 status do not use
trailer# 1245896 status do not use

Sorry for being more clear.

[Weedpacket]

You can group them as you read them in; with each possible status getting its own array. Then you can loop through all of the statuses, and for each status, loop through all the classifications.

$trailers
while($row = mssql_fetch_row($result))
{
	$status = $row['status'];
	$trailers[$status][] = $row;
}

Then you'll have an array $trailers with elements like $trailers['Do Not Use'], which is itself an array of all the trailers with an Off Rent status.

So after you've got your data into the form you want, you can loop through it to display:

foreach($trailers as $status=>$some_trailers)
{
	echo "Trailers that are currently $status";
	foreach($some_trailers as $trailer)
	{
		echo "trailer #".$trailer['TrailerId'];
	}
}

There is of course nothing stopping you from having a richer data structure:

$trailers
while($row = mssql_fetch_row($result))
{
	$status = $row['status'];
	$classification = $row['Classification'];
	$trailers[$classification][$status][] = $row;
}

will group all the trailers by classifcation (wood, etc. I'm guessing), and then for each classifcation, group them by status.

[lmayer4]

Wow, thank you so much. This will help me a lot.

Laura