Retrieving records from remote MySQL using PHP

$result = mysql_query("SELECT * FROM Table") or die("An error occurred: ".mysql_error());

while($row=mysql_fetch_assoc($result)){
   // this will iterate through each row in $result
   // $row will be an associative array with keynames from your database table column names
   // so if your have SELECTed columns with names 'phonenumber' and 'name' you can get the values:

   $phonenumber=$row["phonenumber"];
   $name=$row["name"];

   //   more code

}

$result = mysql_query("SELECT * FROM Table") or die("An error occurred: ".mysql_error());

$json=array();

while($row=mysql_fetch_assoc($result)){
   $json[]=$row;

}
header('Content-type: application/json; charset=UTF-8');
echo json_encode($json);