Caching data

[Floris]

Ok, so I have a script now that I can call as a standalone (blah.php?show=x) which lets me query a remote site tvrage.com for show X. Yay.

This info is going to be shown in the forum that has tv show notes, so the info like next episode, and air date is listed. Of course, we dont' want to trigger this each time a user browses to the page. So it has to get it once, store it in a table:forum field with a timestamp and then check if it has been say .. 12 or 24 hours, before it does a remote query again (and if the time hasn't passed yet, use the existing data).

Now, how do I best approach this? We have about 50 forums, one for each tv show, so we're trying to keep the query count a bit low. I am curious what your thoughts are. Oh, we're already using a plugin to get data from the forum into the tvshownote box. You can check it as example here http://wetalk.tv/heroes/

Thanks for your help.