# Query from mysql in real time

**URL:** <https://forum.kirupa.com/t/query-from-mysql-in-real-time/278763>\
**Category:** Uncategorized\
**Created:** [January 5, 2009, 12:58pm UTC](https://forum.kirupa.com/t/query-from-mysql-in-real-time/278763 "2009-01-05T12:58:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![finalight](https://avatars.discourse-cdn.com/v4/letter/f/919ad9/32.png) [@finalight](https://forum.kirupa.com/u/finalight)\
**Post date:** [January 5, 2009, 12:58pm UTC](https://forum.kirupa.com/t/query-from-mysql-in-real-time/278763/1 "2009-01-05T12:58:59Z")

</div>

my table structure is like this:  
Start\_Date (DateTime)  
End\_Date (DateTime)  
Text (Varchar)

what i need to do is when any record has reach the current date/time, it will display it in the flash, real time. (No resetting of flash or anything like that)

same goes for when the record’s end date has exceed the current date/time; the flash will remove the text from the stage

how am i suppose to do that?
