getmemberdata()

function GetMemberData($mid)
{
   $sql = "
     SELECT
             *,DATE_FORMAT(m_active_date,'%d-%m-%Y') AS aktif
     FROM
             ".$this->pre."member
     WHERE
             RIGHT(m_id,10) = '$mid'
   ";
   //$res = $this->conn->Execute($sql) or die(mysql_error());
   $res = mysql_query($sql) or die(mysql_error());
   $list=array();
   if($res)
   {
     if(mysql_num_rows($res)>0)
     {
       while($res=mysql_fetch_assoc($res))
       {
         $list[] = array(
           'id'=>$fields['m_id'],
           'cat'=>$fields['m_category'],
           'uname'=>$fields['m_username'],
           'password'=>$fields['m_password'],
           'sponsor'=>$fields['m_sponsor_id'],
           'upline'=>$fields['m_upline_id'],
           'serial'=>$fields['m_serial_kartu'],
           'pin'=>$fields['m_pin_kartu'],
           'status'=>$fields['m_status'],
           'join_date'=>$fields['m_join_date'],
           'join_time'=>$fields['m_join_time'],
           'active_date'=>$fields['aktif'],
           'active_time'=>$fields['m_active_time'],
           'cost_signup'=>$fields['m_cost_signup'],
           'ewallet'=>$fields['m_ewallet'],
           'nama'=>$fields['m_first_name']." ".$fields['m_last_name'],
           'fnama'=>$fields['m_first_name'],
           'lnama'=>$fields['m_last_name'],
           'email'=>$fields['m_email'],
           'birthday'=>$fields['m_birthday'],
           'birthplace'=>$fields['m_birthplace'],
           'sex'=>$fields['m_sex'],
           'suku'=>$fields['m_suku'],
           'alamat'=>$fields['m_address'],
           'kota'=>$fields['m_kota'],
           'propinsi'=>$fields['m_propinsi'],
           'country'=>$fields['m_country'],
           'kodepos'=>$fields['m_postalcode'],
           'telepon'=>$fields['m_home_phone'],
           'hp'=>$fields['m_hp'],
           'aktif_agen'=>$fields['m_hp_agen_aktif'],
           'identitas'=>$fields['m_identitas'],
           'no_identitas'=>$fields['m_no_identitas'],
           'pekerjaan'=>$fields['m_pekerjaan'],
           'agama'=>$fields['m_agama'],
           'stat_kawin'=>$fields['m_status_kawin'],
           'waris'=>$fields['m_waris'],
           'hubwaris'=>$fields['m_hub_waris'],
           'bank'=>$fields['m_bank'],
           'norek'=>$fields['m_no_rekening'],
           'atasnama'=>$fields['m_atas_nama'],
           'foto'=>$fields['m_foto'],
           'pass2'=>$fields['m_pass2']
         );
       }
     }
   }
   return $list;
}