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
