<?php
    $db_user = "root";
    $db_pass = "";
    $db_name = "mbooze";

    mysql_connect(localhost,$db_user,$db_pass) or die(mysql_error());
    mysql_select_db($db_name) or die(mysql_error());

    $query = "select drinks.drink_name, drink_types.drink_type_name from drinks, drink_types where drinks.drink_type_id=drink_types.drink_type_id order by drink_name";
    $result = mysql_query($query);

    mysql_close();

    $arr = array();

    while($array = mysql_fetch_array ($result)) {
      $arr[] = array("Drink Name"=>"{$array['drink_name']}", "Type"=>"{$array['drink_type_name']}");
    }
    echo json_encode($arr);
 ?>