mysql dates and validation of dates

[glenwagley]

This maybe should have gone under the general category but I'll give this a whirl as well. I have a database that stores employee records. I have to give the employee the option to go in and edit their records that they have entered via the web. However, they can't edit entries that are older than 4 weeks from the current date. I have the date that they first entered in data in the database. How can I determine if from the date field if it is older than 4 weeks from the current date? Thanks!
-Glen

[klansman]

hi!

depending on the way that you store the date in the mysql database, you may have some mysql functions that can compare that directly.

if that applies to you, you make a select query that returns the row or returns nothing, depending on that date condition... just as simple as that.

check in the mysql documentation... there are big paragraphs about dates, times, date calculations, etc.

[]

[trooper]

Look at the TO_DAYS FUNCTION

here's a snippet of some code that checks the date of the last news item posted to a table

$SQL1=("SELECT TO_DAYS(NOW()) - TO_DAYS('$last_news_entry') AS oldest_news_item");
$result1 = mysql_query($SQL1)or die(mysql_error());
$row = mysql_fetch_row($result1);
if($row[0] < 31)
{

////
}

HTH
GM