[SOLVED] displaying rows

[jakebur01]

How do I echo out these rows I am selecting from the zipcode column?

 

function inradius($zip,$radius)
    {
        global $db;
        $query="SELECT * FROM zipData WHERE zipcode='$zip'";
        $db->query($query);

        if($db->affected_rows()<>0) {
            $db->next_record();
            $lat=$db->f("lat");
            $lon=$db->f("lon");
     $query="SELECT zipcode FROM zipData WHERE (POW((69.1*(lon-\"$lon\")*cos($lat/57.3)),\"2\")+POW((69.1*(lat-\"$lat\")),\"2\"))<($radius*$radius) ";
            $db->query($query);
            if($db->affected_rows()<>0) {
                  while($db->next_record()) {
                    $zipArray[$i]=$db->f("zipcode");
                    $i++;
                }
            }
        }else{
            return "Zip Code not found";
        }
return $zipArray;
    } // end func

} // end class

[jakebur01]

bump

[jakebur01]

Should I be using mysql_query() and mysql_fetch_array()?

 

I know this is something really small.

 

All i'm trying to do is get the rows from that zip code column after the calculation has been made.