Deleting Previous Date

[bjblackmore]

Hi,
I want to delete date out of a mysql dbase, if they have past. So I have $currdate = (date("Ymd")); at the top of my script, then
$sql = "DELETE FROM date WHERE end_date=<'$currdate' AND user_id='$sUserID'";
$result=mysql_query($sql);
But it doesn't seem to work. Should I be using =< or just <?
Cheers
Ben

[cordex]

Converting to UNIX timestamp might an easier comparison. Assuming, for now, $entrydate is a variable containing your Ymd time stamp from your database, use the following bit of code to get the UNIX timestamp and compare from there. (use date("Ymd",$entrytime) to convert back)

$entrytime = mktime (0,0,0,substr($entrydate,4,2),substr($entrydate,6,2),substr($entrydate,0,4));