[Resolved] Problems with SQL Array

[lmayer4]

Okay I was a little confused so I went to the manual. Anyway I have kind of what I want but instead of iterating through all the results it stops at the first.

There should be 4 records only one is showing up. Heres what I have:

/* connect to db */
    $connection=mssql_connect("HQMSDB05") or die("Problem connecting");
    if (!$connection) {
    echo "Could not connect to Sql server!";
    exit;
    }
    //load it all into the associative array
    $sql = "SELECT Source,TrailerID,Status,Length,OwnershipType,Location,Classification,Contents,
            FleetGroup,Description,DoorType FROM Yardcheck.dbo.vwRentalReturns where Source = 'Aberdeen' order by Source";
    $result = mssql_query($sql);
    while($row = mssql_fetch_row($result)) {
    $myArray[$row[0]] = $row[1];
    }
    //now we expand it
    while(list($Source,$TrailerID) = each($myArray)) {
    echo $Source;
    echo $TrailerID;
    echo "<br>";
    }
    ?>

What I get is:

AberdeenU24311

What I would like to see is
Aberdeen
U24311
2400
2411
098924

Then to be extra special I would count at the bottom:
total trailers: 4

But I digress. Can anyone point my confused brain in the right direction. Thanks ever so much

Laura

[kburger]

$result = mssql_query($sql);
while($row = mssql_fetch_row($result)) {
    echo "$row[1]<br>\n";
} 
echo "Total Trailers: ". mssql_num_rows($result);

[lmayer4]

Oh wow that is sooo close to what I need! When I take out the where clause so it will show me everything it first shows me the Facilities and then shows me all the trailers. Is there a way I could group by faclility? I've been messing around with the brackets but I can't seem to come up with the right combination.

Thanks so much.

Laura

[kburger]

Currently, you have your query sorted by 'Source'.

... order by Source

Change it to

... order by Location

or whatever field it is that contains what you're calling 'facility'.

[lmayer4]

I got it. I just made another query and added COUNT to it.

Thanks for all your help.

Laura