Miscellany

$conn = mssql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mssql');
mssql_select_db($dbname);

$uniqueSO=0;
$uniquePO=0;


$SOPartsUsed = "SELECT ItemID, QuantityInvoiced FROM dbo.tblSOPartsUsed";
$SODATA = mssql_query($SOPartsUsed);



while ($row = mssql_fetch_array($SODATA)){
	$uisocount = count($uniqueSO);
	for ($a=0;$a<$uisocount;$a++){
		if (!($row['ItemID'] == $uniqueSO[$a])){
		$uniqueSO[$uisocount+1]=$row['ItemID'];
		$uniqueSO[$uisocount+1]['quantity']=$row['QuantityInvoiced'];
		
		}
		elseif($row['ItemID'] == $uniqueSO[$a]){
		$uniqueSO[$a]['quantity'] = $uniqueSO[$a]['quantity'] + $row['QuantityInvoiced'];
		}
		
	}
}


$POReceived = "SELECT ItemID, QuantityReceived FROM dbo.tblPOReceipts";
$PODATA = mssql_query($POReceived);


while ($row = mssql_fetch_array($PODATA)){
	$uipocount = count($uniquePO);
	for ($b=0;$b<$uipocount;$b++){
		if (!($row['ItemID'] == $uniquePO[$b])){
		$uniquePO[$uipocount+1]=$row['ItemID'];
		$uniquePO[$uipocount+1]['quantity']=$row['QuantityReceived'];
		}
		elseif($row['ItemID'] == $uniquePO[$b]){
		$uniquePO[$b]['quantity'] = $uniquePO[$b]['quantity'] + $row['QuantityReceived'];
		}
		
	}
}

$pocount = count($uniquePO);
$socount = count($uniqueSO);

for ($x=0;$x<$pocount;$x++){
	for ($y=0;$y<$socount;$y++){
		if ($uniqueSO[$x]==$uniquePO[$y]){
		echo "{$uniquePO[$y]} - {$uniquePO[$y]['quantity']} - {$uniquePO[$x]['quantity']}";
		}
	}
}