[RESOLVED] date comparison

slimjim

I have a date in my table called sdate with using type date and it puts in it as yyyy-mm-dd

What I am trying to do is, if a member went into a certain area and that date was put into the database, and if days has gone by since that date, then he can go into the area again, if days has not passed since that date in the database, then he cant access it.

I have gone thru all of this date stuff and cant figure it out. Please help if you can.

Thank You

herve

You can use all the date related functions in MySQL.

Cf : http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

Something like this for instance :

SELECT ... FROM ... WHERE datediff (now(), last_visit) > 10;

where " last_visit' is the column of the table where you store the date of the
last visit of that person. "now()" is the current date and "10" is the number of days
you want to impose between two visits.

If there's an answer to this query, it means there have been more than the delay
otherwise access id denied (of course there must be a condition verifying that the
person is inside the database, otherwise you will deny access to people which
haven't be at least once in the area).

Frederick

if you use the time() function as your date instead of a string time then you can check that time against a calculation.

<?php
// Insert the following variable
$fieldname = time();
?>

Then you can use the following for checking.

<?php
// 86400 represents 24 hours
$checkdate = (time() - 86400);

if ($row['fieldname'] <= $checkdate) {
    echo "No entry allowed";
} else {
    echo "Yahoo";
}

// Display the time in the database
echo date("n/j/y",$row['fieldname']);
?>

slimjim

Geeze and I spent all day reading everything on time and couldnt figure that out...