I'm new here and pretty much an eclectic coder at best so plz be gentle!
Data from a poker tournament is updated in realtime to a database, but we delay the video feed by 20-25 minutes because graphics (i.e. RFID card reader results, etc.) would result in viewers seeing things that players at the table themselves do not - like, everyone elses cards!
That's all handled by proprietary software called PokerGFX, so that part is fine.
But I would like to retrieve the data in the database (seperate from PokerGFX) at the same interval of delay as the video stream to implement a bot with Twitch API so people in Twitch chat can get relevent info like a particular players chip count, but what their chip count was 25 minutes ago, not the realtime data.
I can access the db with MySQL, php and use JS or whatever else is needed. It seems I'm wanting exactly opposite of what everyone else needs...SLOWER data retrieval, not persistent or FASTER LOL!
Thanks for any insight into this.
UPDATE: o but wait there's more: Things have changed, here's what I have:
SELECT * FROM table1 WHERE CurrTime > NOW() - INTERVAL 1 HOUR LIMIT 1";
is giving less than accurate results +- 2 minutes, so I need the most recent record at least 1 hour old. I have tried all kinds of things, interestingly enough, every google result brings me right back here! All of this data loads into an html that auto refreshes every 10 seconds, and I'm finding that if the database is not updated every 60 seconds or so, the html requesting the data goes blank.
