# MySQL, PHP, Flash, and the date() and mktime() php functions

**URL:** <https://forum.kirupa.com/t/mysql-php-flash-and-the-date-and-mktime-php-functions/178275>\
**Category:** flash\
**Created:** [February 9, 2006, 1:25am UTC](https://forum.kirupa.com/t/mysql-php-flash-and-the-date-and-mktime-php-functions/178275 "2006-02-09T01:25:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Psykloak1](https://avatars.discourse-cdn.com/v4/letter/p/7ab992/32.png) [@Psykloak1](https://forum.kirupa.com/u/Psykloak1)\
**Post date:** [February 9, 2006, 1:25am UTC](https://forum.kirupa.com/t/mysql-php-flash-and-the-date-and-mktime-php-functions/178275/1 "2006-02-09T01:25:13Z")

</div>

before I sart, if I use a technical term thats incorrect, I appologize, I’m new to alot of this.

I have a mySQL tabel with a bunch of stats (date, filesize, file name, descriptions) about a bunch of movies. The dates are stored in a timestamp format.

For example, 12/12/98 translates to 913438800 and 4/10/06 is 1144641600

The date is converted from readable format to the timestamp using PHP’s mktime() function. What I need is a way to convert the timestamp back to a readable format in flash.

As I was typing this, I realized I could translate the timestamp in the php file and send in the translated date as a string to flash. anyway, an ideas?