Need a custom query for Photopost Classifieds

[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 1233869618 at 1233869618 ---------------

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);

[Marco van Herwaarden]

If you have questions/problems with a modification or style, then please post in the thread (or support forum/board) about that modification/style. Best chance to receive a reply from either the author or another member using the same modification/style.

[ludachris]

I'm sorry, I thought this was more of a "general programming" forum. I'm just asking about how to write a query. From the other threads I've seen in this forum I'm not sure how this would not be a good forum to ask this question in.

[Dismounted]

$time = strtotime('-90 days');
Is that what you want?

[ludachris]

I think that's what I'm looking for. Thanks!