Developing Mulitdiminsional Array

[eluser]yacman[/eluser]
This is correct then the left joins will fail, causing a null value in that specific roster_name column for the joins.

You can get rid of the ifnull statement all together and just select the columns as inside the IFNULL statements.

Code:

$this->db->select('contender3_user.roster_name as contender3');