Adding / Subtracting Dates

[rpupkin77]

How would I go about testing a date on a record in a db to see if it is today.
Can someone give me some practical coding examples?

Thanks,

paul

[barand]

$sql = "SELECT adate from atable";

$result = mysql_query("$sql);

while (list ($adate) = mysql_fetch_row($result)) {

/* the filed may be date or datetime or timestamp */
/* so make sure time elements removed */
/* and get them in same format */

if (date("Y-m-d", strtotime($adate)) == date("Y-m-d")) {
     echo "$adate - It's today!"<br>
}

}

hth

[rpupkin77]

That worked, but I realized I needed to pull some info out of my db and apply to a date so I used the old to_days mysql function and viola :

$query = "select to_days(now()) as now, ads.ad_id, ads.size, ads.colors, to_days(ads.run_date) as run, ads.description, ads.client, ads.paper_id, papers.paper_name, papers.res_deadline from ads, papers where ads.paper_id = papers.paper_id";

	$result = mysql_query($query);

	$row_count = mysql_num_rows($result);


					//loop
					for ($x=0; $x < $row_count; $x++){
					$array = mysql_fetch_array($result);
					//instantiate variables
					$now = stripslashes($array[now]);
					$ad_id = stripslashes($array[ad_id]);
					$size = stripslashes($array[size]);
					$colors = stripslashes($array[colors]);
					$run = stripslashes($array[run]);
					$description = stripslashes($array[description]);
					$client = stripslashes($array[client]);
					$paper_id = stripslashes($array[paper_id]);
					$paper_name = stripslashes($array[paper_name]);
					$deadline = stripslashes($array[res_deadline]);

					//check for today
					if (($run - 2) == $now) {

					echo $ad_id."<br>";
					}



					}//end  loop

it worked.