Date comparaison

cedricm

Hi everyone,
Here is my little problem: I would like to compare 2 dates.

One is the "day" date et the other comes from MySQL under "date" format (YYYY-MM-JJ)
In one case, I have to compare the entire date with the second date: Day - Month - Year (MySQL)

For the second case I have to compare only the month and the day in order to extract the birthdate of someone on that day (without the year)

PS: In both cases, dates comes from the same place (1 is the date of the day with date()'s function and the other from MYSQL with the format (YYYY-MM-JJ)

Thanks

tekky

and what do you have so far that you are trying this comparison in? did you want the comparison to happen in SQL before PHP sees the data, or AFTER in PHP once you've retrieved the data....

show us how you are trying it and we'll be happy to help... otherwise all we can do is guess at what exactly you mean...

cedricm

I will try to give you a concret example:

$jour = mktime(0,0,0, date("m"), date("d"), date("Y"));

$sql = "SELECT * FROM user_select WHERE date='$jour' ORDER BY $ordered $type";

The field date is formatted as "date" (YYYY-MM-DD) and I need to extract the user(s) who has his birth at the today date and display it.

And the second selection should be:

$sql = "SELECT * FROM user_select WHERE date > '$jour' ORDER BY $ordered $type";

and with this selection the access to the site should be blocked for the user who is expired

PHP should handle the date

Thanks Cedric

tekky

since your date will always be TODAY.... I Would just do

SELECT * FROM users_select where date = now();

and

SELECT * FROM users_select where date > now();