Database cache

I'm trying to do a few queries in PHP script, and it returns some (older) values but not newer values.  Simple SQL queries like:

$query = "SELECT `Date` FROM `table` WHERE `ID` = 1";
$value = db_value($query);

Either shows old values or nothing at all. I'm certain it's to do with Boonex's cache system. I've tried to 'Clean All' and 'Clean DB' in the Admin backend, but it does nothing.  Is there a way to manually disable the DB cache system?

The database cache cannot be disabled. Only html, js and css caching can be disabled.

Try clearing the cache manually which in many cases is the only way it works. The clear cache links in admin don't seem to work well.

From either ftp or cpanals file manager, empty the contents of the cache folder except for the .htaccess file thats in the folder.

Hi hohner,

there is no need for such "caching workaround". You fired up a direct query to db. Normally you would get a string value as result.

You use the db_value func and therfore you have to get always the actual data from your db!

Greetings