<?php

$con = mysql_connect(yourdatabaseaddressprobablylocalhost,yourusername,yourpassword);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db(yourdatabasename, $con);


$result = mysql_query(yourmysqlquery);
while($row = mysql_fetch_assoc($result)){
    $output[]=$row;
}
print(json_encode((array('arrayname'=> $output))));

mysql_close($con);
?>