Re: query, INTERVAL problem

No Jason, what I meant that I submit the date value from a form to MySQL, to execute a query as I said below, and it returns deferent value for that ... when I send $due_date as '20030501' the query return a different than '2003-05-01' Hope I make clear.. "Jason Wong" <php-db@gremlins.biz> wrote in message news:200305271511.22393.php-db@gremlins.biz... > On Tuesday 27 May 2003 14:23, nabil wrote: > > I have many problem when I submit (from form) the $due_date , so when I > > send it as '20030501' it returns with deferent result than > > '2003-05-01' and > > It's not clear what you mean. > > Are you saying: you enter '20030501' into the form and you expect it to come > out as '2003-05-01'? If so this is not going to happen, what you enter is > what you get, the values don't magically transform themselves without further > work on your part. > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.biz > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > ------------------------------------------ > Search the list archives before you post > http://marc.theaimsgroup.com/?l=php-db > ------------------------------------------ > /* > In Hollywood, all marriages are happy. It's trying to live together > afterwards that causes the problems. > -- Shelley Winters > */ >