Mysql query cache?

Hello.
I have a strange problem with my website at work. There is a database
with some product data. Data is registered thru php - website, and
once a week a raport is generated from this data. If a mistake was
made, the data of current week can be corrected in the same way as it
is input. Also there is a part which draws graphs showing registered
data on time based graph.
The problem is, since 2 days something happened and the report
generated shows invalid data - from the current week, not the most
recently corrected. I don't keep corrected data. It's no longer in
database. But it appears in the report. In the graph showing part the
problem doesn't exists. The most recent data is shown there. And
still it uses the same data table.
The problem never happened before (the website exists for many
months).

I'm looking for some advice what could have happened? After rebooting
the computer-server the most recent data was loaded into the report,
and the problem continued if any new corrections were made after the
reboot.

It looks to me that it is some kind of a buffer which holds the
queries...?

I even have screen-printed the query and - following - the results. If
I executed the screen-printed version in SQL-yog - a SQL managing
program - the result was correct. But still in the application - the
data was not up-to-date.

The screen -printed query is:
"select
columns_wr.nazwa2,weekly_sales.value,weekly_sales.week,weekl y_sales.week,columns_wr.event2,columns_wr.product_id
from report.columns_wr,report.weekly_sales
where columns_wr.product_id=weekly_sales.product_id
and columns_wr.product_id=65
and date>='2007-12-10' and date<='2008-01-13' order by date"

Re: Mysql query cache?

Maybe it helps:
The MySQL version is 5.0.37 and the table has six columns (one of
which contains texts about 20-30 chars long) and about 27000 rows.

Re: Mysql query cache?

On 9 Jan, 11:56, michalk...@o2.pl wrote:
> Maybe it helps:
> The MySQL version is 5.0.37 and the table has six columns (one of
> which contains texts about 20-30 chars long) and about 27000 rows.

I'm not sure where php comes into this.

Maybe you'd be better off asking in comp.databases.mysql

Re: Mysql query cache?

On 9 Sty, 13:54, Captain Paralytic wrote:
> On 9 Jan, 11:56, michalk...@o2.pl wrote:
>
> > Maybe it helps:
> > The MySQL version is 5.0.37 and the table has six columns (one of
> > which contains texts about 20-30 chars long) and about 27000 rows.
>
> I'm not sure wherephpcomes into this.
>
> Maybe you'd be better off asking in comp.databases.mysql

This problem is definitely connected with php. If I edit/search data
through mysql-interface everything works perfect. It only happens if I
enter and read data through php web page.

Re: Mysql query cache?

On 9 Sty, 16:58, michalk...@o2.pl wrote:
> On 9 Sty, 13:54, Captain Paralytic wrote:
>
> > On 9 Jan, 11:56, michalk...@o2.pl wrote:
>
> > > Maybe it helps:
> > > The MySQL version is 5.0.37 and the table has six columns (one of
> > > which contains texts about 20-30 chars long) and about 27000 rows.
>
> > I'm not sure wherephpcomes into this.
>
> > Maybe you'd be better off asking in comp.databases.mysql
>
> This problem is definitely connected with php. If I edit/search data
> through mysql-interface everything works perfect. It only happens if I
> enter and read data through php web page.

please check out my next post for more info on this problem