[Resolved] How Many Records Deleted?

[partypete]

Hello,

I have a php page which is executed nightly as a cron job and it's purpose is to delete old records from a database. What I have works fine except that I want it to output how many records where actually deleted. I can't get that part to work for some reason...

<?php
mysql_select_db($database_connMyCalendar, $connMyCalendar);
$query_rs_delete_old_messages = "DELETE FROM calendar_events WHERE event_type = 'M' AND event_read = 'Y' AND event_title != 'DND' AND (TO_DAYS(Now()) - (TO_DAYS(event_added)) >= 30)";
$rs_delete_old_messages = mysql_query($query_rs_delete_old_messages, $connMyCalendar) or die(mysql_error());
$row_rs_delete_old_messages = mysql_fetch_assoc($rs_delete_old_messages);
$totalRows_rs_delete_old_messages = mysql_affected_rows($rs_delete_old_messages);
?>

Messages Deleted: <?php echo $totalRows_rs_delete_old_messages; ?>
<?php
mysql_free_result($rs_delete_old_messages);
?>

Am I using mysql_affected_rows() incorrectly?

$totalRows_rs_delete_old_messages = mysql_affected_rows($rs_delete_old_messages);

Thanks for any help.

Peter

[weekender]

put in some [man]die[/man] bits to output any errors...

$totalRows_rs_delete_old_messages = mysql_affected_rows($rs_delete_old_messages)
    or die("ERROR: " . mysql_error());

[partypete]

I changed:

$totalRows_rs_delete_old_messages = mysql_affected_rows($rs_delete_old_messages);

to:

$totalRows_rs_delete_old_messages = mysql_affected_rows($rs_delete_old_messages) or die(mysql_error());

and now the page no longer deletes the records it should be deleting. No error is printed to the page.

Any other thoughts?

[partypete]

I got it working. I got rid of some code and changed the way I was using mysql_affected_rows(). It now deletes the records and outputs how many were deleted.

<?php
mysql_select_db($database_connMyCalendar, $connMyCalendar);
$query_rs_delete_old_messages = "DELETE FROM calendar_events WHERE event_type = 'M' AND event_read = 'Y' AND event_title != 'DND' AND (TO_DAYS(Now()) - (TO_DAYS(event_added)) >= 30)";
$rs_delete_old_messages = mysql_query($query_rs_delete_old_messages, $connMyCalendar) or die(mysql_error());
$deleted = mysql_affected_rows();
?>
Messages Deleted: <?php echo $deleted; ?>
<?php
mysql_free_result($rs_delete_old_messages);
?>

All's good in the hood....

Thanks

Peter