I did forget to mention that I was using that format.
So it must be something else??
Guy
-----Original Message-----
From: Uma Shankari T. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 16 May 2002 4:09 p.m.
To: Defryn, Guy
Cc: [EMAIL PROTECTED]
Subject: Re: Insert dates with PHP
you have to enter ur date as in this format
YYYY-MM-DD
for example: 2002-04-04
Hope this will work
Uma
On Thu, 16 May 2002, Defryn, Guy wrote:
DG>
DG>
DG>I am working with PHP for the first time and I need a form
DG>To insert some details and a date.
DG>
DG>When I check the mysql database the date is displayed as 0000-00-00
DG>
DG>Here is my php script:
DG>
DG><?
DG>$query = "Insert into
computers(id,itnumber,hdd,processor,ram,monitor,os,invoice,datebought) values" .
"(NULL,'$itnumber','$hdsize','$processor','$ram','$monitor','$os','$invoice'
DG>,'$datebought')";
DG>
DG>mysql_query($query) or die (mysql_error());
DG>
DG>?>
DG>
DG>Everything else works fine. When I enter the date into mysql itself it works fine.
DG>
DG>Thanks
DG>
DG>
DG>---------------------------------------------------------------------
DG>Before posting, please check:
DG> http://www.mysql.com/manual.php (the manual)
DG> http://lists.mysql.com/ (the list archive)
DG>
DG>To request this thread, e-mail <[EMAIL PROTECTED]>
DG>To unsubscribe, e-mail
<[EMAIL PROTECTED]>
DG>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DG>
--
Love and you shall be loved by others
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
