query("SELECT CompanyName, City, Country FROM Customers"); $result = $conn->query("SELECT name, first_name, MRN FROM patient"); $outp = ""; while($rs = $result->fetch_array(MYSQLI_ASSOC)) { if ($outp != "") {$outp .= ",";} $outp .= '{"Name":"' . $rs["name"] . '",'; $outp .= '"FirstName":"' . $rs["first_name"] . '",'; $outp .= '"MRN":"'. $rs["MRN"] . '"}'; } $outp ='{"records":['.$outp.']}'; $conn->close(); echo($outp); ?>