Jump to content

Returning No Results


Xtremer360

Recommended Posts

My aim is for this what if the table is empty which means no results will be retrieved in the first query then I want it to repeat the $testArray as "TBD" as well.

 

 

function getTop5()
    {
        $this->db->select('character1_id, character2_id, character3_id, character4_id, character5_id'); 
        $this->db->from('site_top5');
        $this->db->where('status_id', '1'); 
        $this->db->order_by('id', 'desc'); 
        $query = $this->db->get();  
        $row = $query->row(); 
        $ids = array(
        $row->character1_id,
        $row->character2_id,
        $row->character3_id,
        $row->character4_id,
        $row->character5_id
        );
        
        $testArray = array();
        foreach ($ids as $id) {
            if($id !== "0") {
                $this->db->select('character_name');
                $this->db->from('characters');
                $this->db->where('id', $id); 
                $query = $this->db->get();  
                $row = $query->row(); 
                $testArray[] = $row->character_name;
            } else {
                $testArray[] = "TBA";
            }
        }
        return $testArray;
    }

Link to comment
https://forums.phpfreaks.com/topic/251214-returning-no-results/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.