Date Validation....

[reethu]

Dear All,

Good Day..

I am very new to PHP and I need u r help.

Well, my problem is like this..I want to validate date. Actually I have student information system with MySQL database.

I am capturing student's joining date and ending date of the course and storing it in MySql the below format(example:2003-11-01).

And now I want to select the students those who have joined the course from May to September. And also I want select from October to January End. .

Actually I was trying like this
I have take record from the Database by select statement.
And I assigned $doj for date of joining.
if($doj<=2003-11-01)
{
some statement
}.

But in this case it will select only in the corresonding year. But I want to make it common means without specifing th year.

Please give me some solution..

Thanx.

[LordShryku]

Use the month function is your sql query

SELECT *
FROM   table
WHERE  month(date_joined) BETWEEN 5 AND 9

http://www.mysql.com/doc/en/Date_and_time_functions.html