Old CI install, recently upgraded PHP and MySQL, and now one query doesn’t work...

[eluser]CtheB[/eluser]
wow.. Bob Puzid

sophistry is a well known member of this forum and he is allways in the mood for helping somebody out.
I'm following this forum for a long while, most of the time just reading posts rather then commenting.
I have never seen such a fool as you!
Do never never never again turn against somebody on this forum who is trying to help you!

This is making me very angry. You should be banned from this forum if you do this ever again.
Please make your apologies to sophistry.

Sophistry is asking the right things from you.
With your childish behaviour people like sophistry stop helping people and this is not good for the community.
Thanks to sophistry for helping anybody on this forum!

You can never blame the fact that you are a newbee.
Newbees should read the userguide first and start reading the forum and the wiki before asking questions on the forum!

Your code is a headache for every programmer on the entire world.
Please read the user guide. Here are some must reads:

http://ellislab.com/codeigniter/user-gui...llers.html
http://ellislab.com/codeigniter/user-gui...odels.html
http://ellislab.com/codeigniter/user-gui...views.html
http://ellislab.com/codeigniter/user-gui...guide.html
http://ellislab.com/codeigniter/user-gui...iling.html
http://ellislab.com/codeigniter/user-gui...mples.html
http://ellislab.com/codeigniter/user-gui...sults.html

Please read the whole userguide carefully, then go and play with you code, then come back and ask questions. If you do that and say sorry to sophistry we might help you in the future.

Last but not least: sophistry asked you to do the var_dump() right after the code of the query, if this returns an empty array: there is something wrong with your query. You don't have to use the active record pattern. I'm not doing it either, because native mysql is faster then active record after all!

So you could just do this:

Code:

$query = $this->db->query("
                           SELECT       playerName
                           FROM         player
                           LEFT JOIN    team ON teamId = player_FK_teamId
                           WHERE        teamId = '$this->team'
                           AND          teamActive = TRUE
")

// echo the result of the query so we know that we have some result!
var_dump($query->result());
die();

return $query->result();