I've a mysql database of classified ads. The database itself contains a unique account number, and the (text) ads are pulled into php via the <?php virtual ?> tags, where the ad is accountnumber.htm. The body of the ad does not occur in any database field.
I have a perl script that will delete the old .htm files, but I don't know the best date format for deleting the mysql records. I understand there are a few different formats and/or SELECT calls I can make (right?).
I have date_opened and date_expires fields, but I haven't set them to anything because I don't know the best way to implement them.
It need not be automatic. For now, I would rather have a perl script where I delete the ads with a click of a button.
So, I am looking for (a)optimum date formats that perl can sort through, and (b)please? a code snipped to show me how perl will filter these date formats.
Your suggestions are, as always, greatly appreciated. Thanks in advance!