[ludachris]

For anyone who is familiar with Photopost Classifieds - I'm running version 2.6 and need to renew my membership with them to download the latest version. But right now, I need to create a query that removes all ads older than 90 days. The admin tool allows you to manually delete one at at time, but I have thousands. And many of them have no expiration date.

So basically, I need to run a query that checks the products table and deletes all ads that are 91 days old and older.

Let me know if you need the table names or anything else. Thanks guys.

--------------- Added [DATE]1233869618[/DATE] at [TIME]1233869618[/TIME] ---------------

Am I way off with this query:

list($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime();
$mon = $mon + 1;
$year = $year + 1900;
$today = mktime($hour,$min,$sec,$mon,$mday,$year);
$hour = $hour + ($Globals['numdays'] * 24);
$deleteads = $today - 90;

$query = "DELETE FROM {$Globals['pp_db_prefix']}products WHERE date = $deleteads AND isauction=0";
$result = ppmysql_query($query,$link);