$result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
  // get data and store in a json array
  while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $orders[] = array(
      'OrderDate' => $row['OrderDate'],
      'ShippedDate' => $row['ShippedDate'],
      'ShipName' => $row['ShipName'],
      'ShipAddress' => $row['ShipAddress'],
      'ShipCity' => $row['ShipCity'],
      'ShipCountry' => $row['ShipCountry']
      );
  }

  echo json_encode($orders);