Zip Code db inc convertion help

[rr1024]

Hello again, actually this conversion was easier that expected except my lack of knowledge in actually writing php..lol

Problem is $query is driven by db_arr function which does the mysql array. See code.
When I try to display the array It's all hosed up?

function db_arr( $query )
{
        global $BUG_REPORT_EMAIL;
        global $MySQL,$DEBUG;

       $res = mysql_query( $query, $MySQL->link  );
       if ( !$res )
       {
           $msg="Error in $_SERVER[PHP_SELF]: " . mysql_error() . "\nQuery: '$query'";
           echo PrintErr(_t('_DB_ACCESS_ERROR'));
           db_report_error( $msg);
       }
       $arr = mysql_fetch_array( $res );
       return $arr;
}

My problem is trying to return $query
$zipArray[$key]
with the correct zipcodes.

For sure hands down db_arr function works, it's used all over my site already.
I guess $query is NOT an Array that can be used by it self so I tried to put it in one...LOL and not even that works.

$query=db_arr("SELECT ZIPCode, ($km(POW((69.172*(Longitude-\"$lon\")*cos($lat/57.2958)),\"2\")+POW((69.1*(Latitude-\"$lat\")),\"2\"))) AS distance FROM ZIPCodes WHERE ($km(POW((69.172*(Longitude-\"$lon\")*cos($lat/57.2958)),\"2\")+POW((69.1*(Latitude-\"$lat\")),\"2\")))<= ($radius*$radius) ORDER BY distance $sort");
            //$db->query($query);
            #myquery $db->$query;
            /*if($db->affected_rows()<>0) {*/
            if($query) {
            #myquery if($db->@mysql_affected_rows($db)<>0) { Attemped to replace what they are doing here, didn't work
               $i=0;
                while(list($key, $val)= each($query) ) {
                    $zipArray[$key]=$query['ZIPCode'];
                    $i++;
                }
            }
        }else{
            return "Zip Code not found";
        }

[rr1024]

Can't Seem to get the array to fill up with zipcodes

    function inradius($zipOne,$radius,$units,$sort)
    {
        global $db;

    #-- Trim strip leading and trailing spaces
    $zipOne=trim($zipOne);
   if ($units=="km")
       $km=1.61."*";
   if ( isZipInSystem($zipOne))
        $myZip = db_arr( "SELECT * FROM ZIPCodes WHERE ZIPCode = '$zipOne' ");
   else return "First Zip Code not found";

    if($myZip) {

        $lat=$myZip['Latitude'];
        $lon=$myZip['Longitude'];
        //$query="SELECT ZIPCode, ($km(POW((69.172*(Longitude-\"$lon\")*cos($lat/57.2958)),\"2\")+POW((69.1*(Latitude-\"$lat\")),\"2\"))) AS distance FROM ZIPCodes WHERE ($km(POW((69.172*(Longitude-\"$lon\")*cos($lat/57.2958)),\"2\")+POW((69.1*(Latitude-\"$lat\")),\"2\")))<= ($radius*$radius) ORDER BY distance $sort";
        $query=db_res("SELECT ZIPCode, ($km(POW((69.172*(Longitude-\"$lon\")*cos($lat/57.2958)),\"2\")+POW((69.1*(Latitude-\"$lat\")),\"2\"))) AS distance FROM ZIPCodes WHERE ($km(POW((69.172*(Longitude-\"$lon\")*cos($lat/57.2958)),\"2\")+POW((69.1*(Latitude-\"$lat\")),\"2\")))<= ($radius*$radius) ORDER BY distance $sort");

        if($query) {

        /*   $i=0;
            while(list($key, $val)= each($query) ) {
                $zipArray[$key]=$query['ZIPCode'];
                $i++;
            } */
            $zipArray= fill_array( $query );
           }

    }else{
        return "Zip Code not found";
    }

 return $zipArray;
} // end function

The above is the fuction doing the zipcodes and creating the array...

The next segment is the db_res function

function db_res( $query, $error_checking = 1 )
{
        global $BUG_REPORT_EMAIL;
        global $MySQL;

    $res = mysql_query( $query, $MySQL->link );
    if ( $error_checking && !$res )
    {
            echo PrintErr( _t("_DB_ACCESS_ERROR"));
        $msg = "Error in $_SERVER[PHP_SELF]: " . mysql_error() . "\nQuery: '$query'";
           db_report_error( $msg);
}
return $res;
}

This function creates the array

function fill_array( $res )
{
        global $MySQL;

    if (!$res)
       return false;
    $i = 0;
    while( $r = mysql_fetch_array( $res ) )
        $arr[$i++] = $r;
    return $arr;
}

Finally this snip displays the array

while (list($key, $val) = each($zipArray)) {
   $distance = $zipLoc->distance($myZip,$val,$units);
   $z_arr = db_arr("SELECT Latitude,Longitude FROM ZIPCodes WHERE ZIPCode = '$val'");

   echo "$key => $val = $distance from $myZip at $z_arr[Latitude] and $z_arr[Longitude] <br>";

}

The output has the correct count of elements but the value is always Array...lol
I don't get it can some help or slap me around tell me what I'm doing wrong here?
0 => Array = First Zip Code not found from 94551 at and
1 => Array = First Zip Code not found from 94551 at and
2 => Array = First Zip Code not found from 94551 at and
3 => Array = First Zip Code not found from 94551 at and
4 => Array = First Zip Code not found from 94551 at and
5 => Array = First Zip Code not found from 94551 at and
6 => Array = First Zip Code not found from 94551 at and
7 => Array = First Zip Code not found from 94551 at and
8 => Array = First Zip Code not found from 94551 at and
9 => Array = First Zip Code not found from 94551 at and

[rr1024]

Well either I have stumped the Experts finally or I have BO.......LOL
As it turns out I totally stumbled on the problem.
Was:

function fill_array( $res )
{
        global $MySQL;

    if (!$res)
       return false;
    $i = 0;
    while( $r = mysql_fetch_array( $res ) )
        $arr[$i++] = $r;
    return $arr;
}

Works like this

function fill_array( $res,$table_name )
{
        global $MySQL;

    if (!$res)
       return false;
    $i = 0;
    while( $r = mysql_fetch_array( $res ) )
        $arr[$i++] = $r[$table_name];
    return $arr;
}

Then in the function call to force the array output to actually contain the data

$zipArray= fill_array( $query, "ZIPCode" );

It was kind of loanly on this one, I hope I didn't do anything to offend anyone