help with delete statement

aron

how can i delete everything older than 2 days before todays date.

$date_today = date("Y-m-d");
$sql = "DELETE *FROM open_house WHERE open_date<'$date_today - 2' ";
$sql_result = mysql_query($sql,$connection) or die ("Could not connect to database1");

cheers aron.

keith73

that all depends on what datatype your date is in the database.

also, $date_today = date("Y-m-d") will return 2003-12-18. that's a string. mysql can't just subtract 2 from a string.

keith

aron

its a date field in the database. so how would i grab todays day and minis 2 then delete all from the database.

cheers aron.

LordShryku

All of your answers are in the manual

Shrike

The manual? What's that?

LordShryku

It's that thingy that you keep tucked in the back o the glove comparment of you car, but occasionally pull out to balance the wobbly leg on the kitchen table

G-Net

Originally posted by aron
how can i delete everything older than 2 days before todays date.

$date_today = date("Y-m-d");
$sql = "DELETE FROM open_house WHERE open_date<'$date_today - 2' ";
$sql_result = mysql_query($sql,$connection) or die ("Could not connect to database1");

This might help if it's a datetime field:

<?php
     $intCutOff = strtotime("-2 days");
     $sql = "DELETE FROM open_house WHERE open_date < '" . date("Y-m-d h:i:s", $intCutOff) . "' ";
     $sql_result = mysql_query($sql,$connection) or die ("Could not connect to database1");
?>

If it's a timestamp, it should work with just $intCutOff. I would test it with a select before running it, to make sure you get you're desired results. :p

HTH!