does mysql cache????

Hi there, this time I am seeing something very odd with mysql thast appears to be caching queries.

I have a set of objects which allow me to genericly create an admin tool for a database.

I had made some changes to one table and was surprised to see that the function I use to get the enum choices (lifted from the php site) which had been working perefectly was not picking up the 2 choices for the 2 new enaum types. The query to get the rest of the info was updating but not the 'describe' I was using.

I checked the obvisous that it didn;t need a page refresh and the enaums were at the end so I added one near the top and edited the copde to show the field name it was checking. Lo and behold it was sliding right over the new one I put in it!

So do the describe queries get cached?
what else could it be?

I did a describe in phpmyadmin and it showed them all. I am at a loss! thanks in advance

how bad can my typing be huh!, sorry bout that

found a tough oine have? :-)

well after scouring the myswl documentation I tried serveral flush commands, I got access denied on any that were accepted.

FLUSH TABLE tblname
FLUSH QUERY CACHE
RESET QUERY CACHE

etc

Any ideas please?

ok, it was me. nevermind!