<?php
if(empty($errorMsg) && isset($_REQUEST['originId']) && !empty($_REQUEST['originId']))
{
    $originId = intval($_REQUEST['originId']);
    if ($result = $mysqli->query("SELECT OriginDestination.DestinationId
    FROM OriginDestination
    WHERE OriginDestination.OriginId = '" . $originId . "' AND OriginDestination.RollOnRollOff = 1 AND OriginDestination.Live = 1;"))
    {
        if($result->num_rows == 0)
        {
            $errorMsg[] = 'No trade routes have been found';
        }
        else
        {
            $xmlContent = $xml->addChild('RollOnRollOff');
	        while ($row = $result->fetch_object())
	        {
                $xmlDestination = $xmlContent->addChild('Destination');
	            $xmlDestination->addChild('Id', intval($row->DestinationId));
	        }
        }
    }
    else
    {
	    print $mysqli->error;
	    exit;
    }
    $result->close();
}
?>