an Array issue

[Hobbyist_PHPer]

I'm having problems populating my array... logically the code seems fine to me, any ideas?

 

            $query = mysql_query("SELECT ALU_7705_Statuses.StatusID, ALU_7705_Statuses.SiteID, Sites.SiteName FROM ALU_7705_Statuses LEFT JOIN Sites ON ALU_7705_Statuses.SiteID = Sites.SiteID WHERE ALU_7705_Statuses.Market = '$_SESSION[AllowedMarket]' AND ALU_7705_Statuses.CompleteIncomplete = 'Incomplete'", $a_link);
            $resultcount = mysql_num_rows($query);
            while ($row = mysql_fetch_assoc($query)) {
                $StatusID = "";
                $SiteName = "";
                $DateTimeOfStatus = "";
                $Status = "";
                $Statusor = "";
                $Notes = "";
                $subquery = mysql_query("SELECT Status_Reports.TechID, Status_Reports.DateTimeOfStatus, Status_Reports.Status, Status_Reports.Notes, Users.FirstName, Users.LastName FROM Status_Reports LEFT JOIN Users ON Status_Reports.TechID = Users.UserID WHERE Status_Reports.StatusID = '$row[statusID]' ORDER BY StatusReportID DESC LIMIT 1", $a_link);
                while ($subrow = mysql_fetch_assoc($subquery)) {
                    $StatusID = $row['StatusID'];
                    $SiteName = $row['SiteName'];
                    $DateTimeOfStatus = $subrow['DateTimeOfStatus'];
                    $Status = $subrow['Status'];
                    $Statusor = $subrow['FirstName'].' '.$subrow['LastName'];
                    $Notes = $subrow['Notes'];
                    echo '
            <tr><td><a href="sitestatrep.php?StatusID='.$row["StatusID"].'">'.$row["SiteID"].'</a></td>
                    <td>'.$row["SiteName"].'</td>
                    <td>'.date("M j, Y g:i a", strtotime($subrow["DateTimeOfStatus"])).'</td>
                    <td>'.$subrow["Status"].'</td>
                    <td>'.$subrow["FirstName"].' '.$subrow["LastName"].'</td>
                    <td>'.substr($subrow["Notes"], 0, 22).' ';if($subrow['Notes'] != ""){echo'...';}echo '</td>
            </tr>';
                }
                for ($i=0;$i<$resultcount;$i++) {
                    $resultsarray[$i]["StatusID"] = $StatusID;
                    $resultsarray[$i]["SiteName"] = $SiteName;
                    $resultsarray[$i]["DateTimeOfStatus"] = $DateTimeOfStatus;
                    $resultsarray[$i]["Status"] = $Status;
                    $resultsarray[$i]["Statusor"] = $Statusor;
                    $resultsarray[$i]["Notes"] = $Notes;
                }
            }

 

But when I print_r it, it filled all of the values with the last row of data...

[sasa]

try

$i = 0;
$query = mysql_query("SELECT ALU_7705_Statuses.StatusID, ALU_7705_Statuses.SiteID, Sites.SiteName FROM ALU_7705_Statuses LEFT JOIN Sites ON ALU_7705_Statuses.SiteID = Sites.SiteID WHERE ALU_7705_Statuses.Market = '$_SESSION[AllowedMarket]' AND ALU_7705_Statuses.CompleteIncomplete = 'Incomplete'", $a_link);
            $resultcount = mysql_num_rows($query);
            while ($row = mysql_fetch_assoc($query)) {
                $StatusID = "";
                $SiteName = "";
                $DateTimeOfStatus = "";
                $Status = "";
                $Statusor = "";
                $Notes = "";
                $subquery = mysql_query("SELECT Status_Reports.TechID, Status_Reports.DateTimeOfStatus, Status_Reports.Status, Status_Reports.Notes, Users.FirstName, Users.LastName FROM Status_Reports LEFT JOIN Users ON Status_Reports.TechID = Users.UserID WHERE Status_Reports.StatusID = '$row[statusID]' ORDER BY StatusReportID DESC LIMIT 1", $a_link);
                while ($subrow = mysql_fetch_assoc($subquery)) {
                    $StatusID = $row['StatusID'];
                    $SiteName = $row['SiteName'];
                    $DateTimeOfStatus = $subrow['DateTimeOfStatus'];
                    $Status = $subrow['Status'];
                    $Statusor = $subrow['FirstName'].' '.$subrow['LastName'];
                    $Notes = $subrow['Notes'];
                    echo '
            <tr><td><a href="sitestatrep.php?StatusID='.$row["StatusID"].'">'.$row["SiteID"].'</a></td>
                    <td>'.$row["SiteName"].'</td>
                    <td>'.date("M j, Y g:i a", strtotime($subrow["DateTimeOfStatus"])).'</td>
                    <td>'.$subrow["Status"].'</td>
                    <td>'.$subrow["FirstName"].' '.$subrow["LastName"].'</td>
                    <td>'.substr($subrow["Notes"], 0, 22).' ';if($subrow['Notes'] != ""){echo'...';}echo '</td>
            </tr>';

                    $resultsarray[$i]["StatusID"] = $StatusID;
                    $resultsarray[$i]["SiteName"] = $SiteName;
                    $resultsarray[$i]["DateTimeOfStatus"] = $DateTimeOfStatus;
                    $resultsarray[$i]["Status"] = $Status;
                    $resultsarray[$i]["Statusor"] = $Statusor;
                    $resultsarray[$i]["Notes"] = $Notes;
                    $i++
                }
            }

[Hobbyist_PHPer]

Thank you, that worked... Excellent