array | select

boas...

estou com um problema e nao estou conseguindo resolver

o meu problema é o seguinte estou tentando substituir um array por um select

cria que ao lista-se os dados fosse a partir de uma tabela da base de dados mas nao estou conseguindo listar

<?php

 $aUsers = array(
 "Ädams, Egbert",
 "Altman, Alisha",
 "Archibald, Janna",
 "Auman, Cody",
 "Bagley, Sheree",
 "Ballou, Wilmot",
 "Bard, Cassian",
 "Bash, Latanya",
 "Beail, May",
 "Black, Lux",
 "Bloise, India",
 "Blyant, Nora",
 "Bollinger, Carter",
 "Burns, Jaycob",
 "Carden, Preston",
 "Carter, Merrilyn",
 "Christner, Addie",
 "Churchill, Mirabelle",
 "Conkle, Erin",
 "Countryman, Abner",
 "Courtney, Edgar",
 "Cowher, Antony",
 "Craig, Charlie",
 "Cram, Zacharias",
 "Cressman, Ted",
 "Crissman, Annie",
 "Davis, Palmer",
 "Downing, Casimir",
 "Earl, Missie",
 "Eckert, Janele",
 "Eisenman, Briar",
 "Fitzgerald, Love",
 "Fleming, Sidney",
 "Fuchs, Bridger",
 "Fulton, Rosalynne",
 "Fye, Webster",
 "Geyer, Rylan",
 "Greene, Charis",,
 "Hoenshell, Eulalia",
 "Isaman, Lalo",
 "James, Diamond",
 "Jenkins, Merrill",
 "Jube, Bennett",
 "Kava, Marianne",
 "Kern, Linda",
 "Klockman, Jenifer",
 "Lacon, Quincy",
 "Laurenzi, Leland",
 "Leichter, Jeane",
 "Leslie, Kerrie",
 "Lester, Noah",
 "Llora, Roxana",
 "Lombardi, Polly",
 "Lowstetter, Louisa",
 "Mays, Emery",
 "Mccullough, Bernadine",
 "Mckinnon, Kristie",
 "Meyers, Hector",
 "Monahan, Penelope",
 "Mull, Kaelea",
 "Newbiggin, Osmond",
 "Nickolson, Alfreda",
 "Pawle, Jacki",
 "Paynter, Nerissa",
 "Ryals, Titania",
 "Saylor, Lenora",
 "Schofield, Denice",
 "Schuck, John",
 "Scott, Clover",
 "Smith, Estella",
 "Smothers, Matthew",
 "Stainforth, Maurene",
 "Stephenson, Phillipa",
 );

 $input = strtolower( $_GET['input'] );
 $len = strlen($input);
 $limit = isset($_GET['limit']) ? (int) $_GET['limit'] : 0;

 $aResults = array();
 $count = 0;

 if ($len)
 {
 for ($i=0;$i<count($aUsers);$i++)
 {
 // had to use utf_decode, here
 // not necessary if the results are coming from mysql
 //
 if (strtolower(substr(utf8_decode($aUsers[$i]),0,$len)) == $input)
 {
 $count++;
 $aResults[] = array( "id"=>($i+1) ,"value"=>htmlspecialchars($aUsers[$i]), "info"=>htmlspecialchars($aInfo[$i]) );
 }

 if ($limit && $count==$limit)
 break;
 }
 }

 header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
 header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
 header ("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
 header ("Pragma: no-cache"); // HTTP/1.0

 if (isset($_REQUEST['json']))
 {
 header("Content-Type: application/json");

 echo "{\"results\": [";
 $arr = array();
 for ($i=0;$i<count($aResults);$i++)
 {
 $arr[] = "{\"id\": \"".$aResults[$i]['id']."\", \"value\": \"".$aResults[$i]['value']."\", \"info\": \"\"}";
 }
 echo implode(", ", $arr);
 echo "]}";
 }
 else
 {
 header("Content-Type: text/xml");

 echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?><results>";
 for ($i=0;$i<count($aResults);$i++)
 {
 echo "<rs id=\"".$aResults[$i]['id']."\" info=\"".$aResults[$i]['info']."\">".$aResults[$i]['value']."</rs>";
 }
 echo "</results>";
 }
 ?>
 

o select que tentei fazer foi este

 

 

 $x = 0;
 $query = mysql_query("SELECT * FROM countries");
 while($row = mysql_fetch_array($query)){
 $aUsers[$x] = $row['values'];
 $x++;
 }

alguem pode ajudar, nao estou conseguindo

cumps