$query = "
select itemId, WeekNumber from StockAlerts
inner join WeekDates on WeekDates.WeekEndDate =StockAlerts.WeekEndDate
";
$result9 = $fon->odbprepSelect($query9);
foreach ($result9 as $row9) {


    if ($a_row['item_id'] AND $a_row['week_no'] == $row9['itemId'] And $row9['WeekNumber']) {



        ?><td align="center" style="border-bottom: 1px solid #ddd;border-right: 1px solid #ddd;" bgcolor="#D0A9F5"   ><?php echo "qty_ordered_sum"; ?></td> <?php


      if ((int)$Units === 0) {
?>
                    <td align="center" style="border-bottom: 1px solid #ddd;border-right: 1px solid #ddd;" bgcolor="#F2F5A9" >-</td>
<?php
            } else {
?>
                    <td align="center" style="border-bottom: 1px solid #ddd;border-right: 1px solid #ddd;" bgcolor="#F2F5A9" ><?php echo $Units; ?></td>
<?php



            }


            }




    else {
?>
    <td align="center" style="border-bottom: 1px solid #ddd;border-right: 1px solid #ddd;" bgcolor="#D0A9F5"   ><?php echo $qty_ordered_sum; ?></td>


<?php
            if ((int)$Units === 0) {
?>
                    <td align="center" style="border-bottom: 1px solid #ddd;border-right: 1px solid #ddd;" bgcolor="#F2F5A9" >-</td>
<?php
            } else {
?>
                    <td align="center" style="border-bottom: 1px solid #ddd;border-right: 1px solid #ddd;" bgcolor="#F2F5A9" ><?php echo $Units; ?></td>
<?php
            }



            }




            }