Page 1 of 1

Emer...gen...cy?

Posted: Wed Mar 28, 2007 7:09 pm
by Mightywayne
Uhm hello. Very odd happening here.

Randomly, out of nowhere, my mysql_fetch_arrays do not work.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

But uhm, there's nothing wrong with them. Like these have been looking fine and working correctly for about 2 months, and out of nowhere they don't work anymore?

I'm wondering, maybe, is anyone else having this problem? Likely not, so... I'm on a shared server. Do you think there's a command in their depths of PHP file that is stopping the fetching from working? They might be upgrading PHP or something.

It's only fetching, I can see so far. This is terrible because I'm on a deadline I'd like to meet.

Posted: Wed Mar 28, 2007 7:20 pm
by daedalus__
Mightywayne wrote:I'd just like to say that before each question I ask, I research it in Google, to save me and you time.
That error may indicate that the query failed. You should put some error checking around your query and sniff it out.

Posted: Wed Mar 28, 2007 7:34 pm
by Mightywayne
Cute... I checked a few places to see if maybe PHP was having a global problem or not.

Something did come up, and it shouldn't be acting like this. Give me a second.

And, thank you, for your help.

Edit: How embarrassing. It was actually a combination of two stupid mistakes at once. Suits me for working on two scripts at once.

Sorry for wasting your time, if there is a kind mod out there, you can close/delete this embarrassing topic.

Posted: Wed Mar 28, 2007 7:38 pm
by daedalus__
If you can post your code I will give you suggestions.

Posted: Wed Mar 28, 2007 10:02 pm
by RobertGonzalez
Almost 100% of the time, the not a valid result resource means that your query is jacked up, not that the function is broken. And no, the mods are not going to delete this thread. Though posting your fix would be nice.