-------------------------------------------------------------------------------------
$result = mysql_query ("SELECT* FROM postcodes");
while (list(,$areacode)= mysql_fetch_array($result)){
$areaone = sprintf (" %s", $result);
}
print $areaone;
-------------------------------------------------------------------------------------