Php/mysql cacheing?

PHP
1

Hey guys,

I dont have time to post my code, really need to sleep but basically i am calling a method within a while loop that makes considerable MySql calls, im outputting tables of results however all that happens is that the first item that is looped gets outputted over and over despite me being 100% sure it should be printing out information relevant to the current item.

Bit of a nightmare, the only thing i can think of is some kind of cache, such a pain.

Cheers for any help, kind of hoping that someone has had an identical problem.

2

Your code is wrong, post it. :stuck_out_tongue:

3

I got it! i was saving an array statically then processing the data from it to save resources! silly of me to have not noticed, that’s why sleep is good. Thanks for the offer of support though, appreciated, i would be screwed without sitepoint.