> when I send $due_date as '20030501' the query return a different than > '2003-05-01' As Jason said initially, you can't expect the database to magically transform the $due_date into DATE format. You need to process the string before you try to work with it in SQL. $due_date = strtotime( $due_date ); $due_date = date( "Y-m-d", $due_date ); Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "nabil" <nabil.attar@aws-syria.com> To: <php-db@lists.php.net> Sent: Tuesday, 27 May, 2003 05:03 Subject: 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 200305271511.22393.php-db@gremlins.biz">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 > */ > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
