PHP。 如何比较多个日期列并回显下一个即将到来的日期的行。

Question

I have a database of expiry dates. In this database I have 4 columns specifically for dates. I want to be able to compare all the 4 dates (in the 4 columns) for each of the rows and echo the database ordered by those expiring soon on top followed in that order. To be more clear : the 4 dates in each row should be compared to the ones in other rows and there is no need for any logic here. even if one date in one of the row is earlier then any other date in the other row then that row with the former date should be echoed first. My question is can I use PhP conditional statements to compare dates. If not how else can i approach this problem ?

Answer 1

Use time stamps!

You could fetch them in sql by

UNIX_TIMESTAMP(yourdate)

In your select statement