Posted by michalkuls on 01/09/08 16:49

I have recently recognized a problem, described it in a post a few
hours ago, but have revised my opinion on the problem. Now it looks as
follows:
The portal runs on apache/php/mysql. Php generates a query, and the
result returned is from a cache, not from the actual mysql db. The
data I receive is not up-to-date - to changes I make during this
time.
I have tried using mysql_unbuffered_query, but doesn't help.
I have finally come to the solution. At the end of list of fields
following SELECT statement, I entered rand() function which causes
that every query is different from the previous...
Looks like this: SELECT field1,field2,...,rand() FROM ...

But this solution is ugly and very unproffesional.
Do you have any better idea?
How to stop php/apache from buffering/caching mysql query results?

Thanks for any hints
Michal

[Back to original message]