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.