# PHP/mySQL date

**URL:** <https://forum.kirupa.com/t/php-mysql-date/70900>\
**Category:** programming\
**Created:** [November 18, 2004, 6:30pm UTC](https://forum.kirupa.com/t/php-mysql-date/70900 "2004-11-18T18:30:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mbo108](https://avatars.discourse-cdn.com/v4/letter/m/aeb1de/32.png) [@mbo108](https://forum.kirupa.com/u/mbo108)\
**Post date:** [November 18, 2004, 6:30pm UTC](https://forum.kirupa.com/t/php-mysql-date/70900/1 "2004-11-18T18:30:46Z")

</div>

I’m displaying sales data on a php page. There is a “sale” table in my database. The fields are saleID, saleItem, salePrice, and saleEnd. I want saleEnd to be in some type of DATE format, but there are a lot to choose from. Also, I want to my php statement to be able to choose only those saleItems who’s saleEnd DATE has not passed. Is there a way to do this?

I am developing these php pages with Dreamweaver MX and I use phpMyAdmin to alter the mySQL databases.