I have a query that I would have liked to cache, but as it uses UNIX_TIMESTAMP and has a user variable in it, where cacheing won't work, I looked around for another way to do it (it is used to create a smallish < 50 records table on each web page, so any speed increase is worthwhile).
I decided to go for the creation of a HEAP table, so that anyone accessing the site would automatically access it. The existence of the table is tested for before initial creation by running a select against it and testing the $result variable. This works, as far as it goes, but it will require occasional updating. And that's where I've come unstuck. How can I test for the time/date of the HEAP table's creation? If I can find that, then I can set a seconds value past which it should be dropped and recreated. Any ideas? Using MySQL 5.0.13, php 4.3.2 (on Windows XP), Apache 1.3 whatever. This also has to work on the website proper, using 5.0.13/4.3.1 and IIS5. Terry Riley -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php