[SOLVED] MySQL Date field help with searching

[cooldude832]

I want to be able to search by things with a certain date field like:

Last 10 days

last 5 days

last 3 day

yesterday

today

 

and I have a field that is a Date so I want to say WHERE CDate >= '$searchdate';

I do this, but its altering my year not day

 

	$temptoday = date("Y-m-d");
	$tempcdate = $temptoday-$searchc['date'];
	$critera .= "WHERE CDate >= '".$tempcdate."' ";
	$whereset = "yes";

 

[cooldude832]

I've reworked it, but still no good

	$tempcdate =  mktime(0,0,0,date("m"),date("d")+$search['date'],date("Y"));
	$tempcdate = date("Y-m-d", $tempcdate);

[cooldude832]

problem solved I had the + instead of - for subtracting days