Printing only NOT NULL datas from MySql query

[eluser]Phil Sturgeon[/eluser]
Surely just:

Code:

function get_profileByID($id)
    {
        $query = $this->db->getwhere('nip_profile', array('profile_ID' => $id, 'active' => 1));

        // Is there any results ?
        if(!$query->num_rows() > 0)
        {
            return false;
        }


        // @TODO: Tester tous les champs NULL et ne renvoyer que ceux-ci pour n'afficher que ceux-ci


        foreach($query->result() as $row)
        {
            $data = array(  'is_human'      => $row->is_human,
                            'active'        => $row->active,
                            'created'       => $row->created,
                            'modified'      => (isset($row->modified) ? $row->modified : '',          // Possible NULL
                            'name'          => $row->name,
                            'website'       => (isset($row->website) ? $row->website : '',           // Possible NULL
                            'origin'        => (isset($row->origin) ? $row->origin : '',            // Possible NULL
                            'based_at'      => (isset($row->based) ? $row->based_at : '',          // Possible NULL
                            //etc
            );

            // If birthdate is not Null, we convert it to Age
            if($row->date_of_birth)
            {
                $data['age'] = mysqldate_to_age($row->date_of_birth);
            }

        }

        return $data;
    }