On Thursday 30 May 2002 20:25, Jack wrote:
> Dear all
> I had a Input form for user to input the Leave Record,
> I want to do some check before the record can insert into database!
>
> Here is the problem i had when checking the Leave From Date and Leave To
> Date.
> I want to prevent any Leave To Date which is earlier then Leave From Date.
> how i can do the comparsion? I had tried to use the following script but it
> doesn't work!
>
> <?
> $a=$leave_form
> $b=$leave_to
>
> if ($a<$b)
> {
> insert statement
> }
>
> ?>
>
> It doesn't work since i use the < Operator!
>
> Does anyone know how i can perform this comparsion?

Convert both dates to a UNIXTIMESTAMP then do the comparison.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *


/*
Politics makes strange bedfellows, and journalism makes strange politics.
                -- Amy Gorin
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to