Date Validation....

[reethu]

Dear All,

I want to validate the Date. Please find the coding and please clear my toubt.

I have selected the Date of Joiniing of a particular student and I defined as

$doj.

Please see the below coding

$datequery="Select * from student_profile where StudentID='$studentid' ";
echo "$datequery";
$datequery1=mysql_query($datequery);
while($datequery2=mysql_fetch_array($datequery1))
{
$doj=$datequery2["DOJ"];
}
echo "The date is $doj";

The result will be like this 2003-11-01

Now I want to check whether $doj falls between 1st May to 30th September.

How can I check this???

Thats what I want to know.

Thanx a lot..

Regards,
Richard.

[jsim]

You can select day and month using the following sql query:

select *,dayofmonth(doj) as doj_day,month(doj) as doj_month from student_profile where StudentID='$studentid'

Now you can check date in your php code (after data fetching):

if( ($doj_month >= 5) && ($doj_month <= 9) ) {
  // date falls between 1st May and 30th Sep
}

Note that you don't really need to fetch doj_day - but if you want to check doj for falling into the 5th May and 23 Jul you must check doj_day too.

Also you can optimize your sql query to fetch only needed rows (check you date directly in sql not in php code) by using "select ... where doj_month>=5 and doj_month<=9"