[djbaxter]

A hint on another forum got me closer.

Using this:

<?php 

require ("global.php"); 
$time = time() - (25 * 24 * 60 * 60); 

// $a = $DB_site->query("DELETE FROM privatemessage WHERE dateline < $time"); 
// $a = $DB_site->query_first("SELECT COUNT(*) AS oldpms FROM privatemessage WHERE dateline < $time"); 
// print "Total PMs To Be Deleted: $a[oldpms]"; 

// $a = $DB_site->query("DELETE FROM vbpm WHERE pmtextid IN(SELECT pmtextid FROM vbpmtext WHERE dateline < $time)); 
// $a = $DB_site->query("DELETE FROM vbpmtext WHERE pmtextid IN(SELECT pmtextid FROM vbpmtext WHERE dateline < $time)); 

 $a = $db->query_first("SELECT COUNT(*) AS oldpms FROM vbpm WHERE pmtextid IN(SELECT pmtextid FROM vbpmtext WHERE dateline < $time)"); 
 print "<br />Total PMs To Be Deleted: ";
 print $a['oldpms'];
$a = $db->query_first("SELECT COUNT(*) AS oldpms FROM vbpmtext WHERE pmtextid IN(SELECT pmtextid FROM vbpmtext WHERE dateline < $time)"); 
print "<br />Total PMtexts To Be Deleted: ";
print $a['oldpms']; 
?>

I get this:

Total PMs To Be Deleted: 9687
Total PMtexts To Be Deleted: 4771

The questions is why are those two counts different? Shouldn't they be the same?