I want to delete all rows in a database that are older then 4 months.

I have a column called 'logdate' which holds the date that the data was entered.

Here's my current code:

Code:
$today = date("d/m/Y", strtotime("-120 day"));

mysql_query("DELETE FROM logtable WHERE logdate < '" . $today . "'") or die(mysql_error());
This however deletes everything.