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

[eluser]sophistry[/eluser]
[quote author="Bob Puzld" date="1240423637"]You know what Research, stick it. I have had enough of your insulting comments and aimless assistance. Either you want to help or shut the FU. I have told you numerous times that I am new to this stuff and just looking for some guidance, in order to help a friend. And you are right, you don't have to help, so do me a favor and don't reply anymore. I will try to find assistance elsewhere.[/quote]

wow.

that was uncalled for.

if CI forums had a frowny-face smiley, i would use it right now. instead i'll just say i am upset by your tone of voice. :down:

[eluser]Bob Puzld[/eluser]
was it uncalled for?? hmmmm

[eluser]sophistry[/eluser]
bob, now you are just taunting me. please return to the topic of this thread or start a new one.

[eluser]Jay Logan[/eluser]
If your URL's don't include the index.php file, trying editing your config.php file so that the uri_protocol index is set to "REQUEST_URI". This once was a problem for me after I upgraded my PHP.

[eluser]Bob Puzld[/eluser]
Click----ignore.

[eluser]Bob Puzld[/eluser]
Thanks J-Slim. I will take a look at your suggestion.

[eluser]Bob Puzld[/eluser]
J-Slim, I finally tried REQUEST_URI as you recommended. I did not change anything though. Thanks for the recommendation. Any other thoughts?

-Bob

[eluser]Jay Logan[/eluser]
That's all I got. Are you getting any errors or anything? If it's just showing incorrect result, it's most likely something with the model. I don't see what you have in your model though.

[eluser]Bob Puzld[/eluser]
Here is what it displays(below), and the kicker is that the table does have payment requests in it.


Payments Requested (0)

array(0) {
}

No pending payouts.

[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();