<?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("aaData"=>null, "aoColumns"=>null);
    $data = array();
    while($array = mysql_fetch_array ($result)) {
      $data[] = array($array['drink_name']}, $array['drink_type_name']);
    }
    $arr['aaData'] = json_encode($data);

   /*
    * SUGGESTION:
    * STATICALLY GENERATE COLUMN HEADINGS ARRAY
    * You already know what they are going to be and they're not going to change
    */


    echo json_encode($arr);
 ?>