[SOLVED] - Interesting MySQLi issue - Stored Procedures with Multiple Results.

[eluser]Tim Brownlaw[/eluser]

It’ll be something soooo simple I’m missing it.

Hmm time to get out the towels to wipe the mud from my face.

Some dozey programmer who had a changes file to his database and DIDN'T install them needs a good kicking up the backside - OUCH! that hurt!

Why hadn't I put the changes into the main tables file........I have now!

But good did come from all this...

1. proves that my additions to mysqli_result to handle multiple result sets works.
2. proves a days rest in between attempts when the obvious becomes oblivious, gets rid of the mental fog.
3. I refined my "sample php code documenter" to make it very uesful.

I have to add that the Folk at HostGator were most supportive wanting to dive in and help out once I got the code together. Which resulted in point 3 above! So a big thankyou to the Hostgator Crew!

The Moral of the story is...
When something don't work somewhere that does somewhere else - most likely you've forgotten to install / load something.

Unfortunately Stored Procedures - unless you tell them to explicilty - won't complain much - they'll just come back with no result. Which is exactly what was happening.

I hope you get a good chuckle out of this.

Now I can get some work done!

Cheers
Tim