date

[Anon]

hi
the peoples in israel writes the date like this 21/11/01 .
if i'm using this function: date('d/m/y',time());
so i get 21/11/01 .
so far so good, but when i put it in mysql DB it goes wrong
it automaticly changes the format, if i use VARCHAR, i can't
do conditions lile

<?
$date=date('d/m/y',time());
if($date>21/11/01)
print "the time is lost";
if ($date<21/11/01)
print "u have" echo $more_days; print"days left";
?>

or something like that, wht do u say?
dnt send me to www.php.net

thanks
avi

[Anon]

I think i this case u use datetime so it works fine

Mandar Kelkar

[Anon]

how do i use it?
can u please explain yourself?
what do i do with MYSQL