[RESOLVED] delete question

[slimjim]

I know this is going to sound dumb but I need to know how to do a delete by date

I am using date type Y-m-d 0000-00-00

I want to delete all from tabe anything 6 months or older
But I also need to use it as a varible like:

$oldt="6";//which would be 6 months

$sql = "DELETE FROM trials WHERE listed <= '".date("Y-m-d", strtotime("-$oldt months"))."'";
//But i dont think this is correct...

[slimjim]

This is the part I dont think is correct :
("-$oldt months")

[pppppp]

u can use
$sql = "DELETE FROM trials WHERE listed <= '".date("m-d-Y", mktime(0,0,0,date("m")-6,date("d"),date("Y")))."'";
this should work

[slimjim]

Can I do it this way ?

$oldt = 6;

$sql = "DELETE FROM trials WHERE listed <= '".date("m-d-Y", mktime(0,0,0,date("m")-$oldt,date("d"),date("Y")))."'";

or do i have to do it like this :

$sql = "DELETE FROM trials WHERE listed <= '".date("m-d-Y", mktime(0,0,0,date("m")-".$oldt.",date("d"),date("Y")))."'";

Or is that wrong too ? Sorry just confused

[slimjim]

Ok here is what I came up with that works

$crontdelete = 6;
$sql = "DELETE FROM trials
         WHERE listed <= '".date("Y-m-d", strtotime("-$crontdelete months"))."'";
mysql_query($sql);