Fetch mysql results into an array using PHP


$selectSites = mysql_query("SELECT Site_Id FROM CMS_User_SiteAccess_Details WHERE User_Id = '$selectedUserId'");
$ctrSites = 0;
while ($row = mysql_fetch_array($selectSites, MYSQL_NUM)) {
$AssignedSites[$ctrSites] = $row[0];
$ctrSites++;
}