Insert dates with PHP

2002-05-15 Thread Defryn, Guy
I am working with PHP for the first time and I need a form To insert some details and a date. When I check the mysql database the date is displayed as -00-00 Here is my php script: ? $query = Insert into computers(id,itnumber,hdd,processor,ram,monitor,os,invoice,datebought) values .

Re: Insert dates with PHP

2002-05-15 Thread Uma Shankari T.
you have to enter ur date as in this format -MM-DD for example: 2002-04-04 Hope this will work Uma On Thu, 16 May 2002, Defryn, Guy wrote: DG DG DGI am working with PHP for the first time and I need a form DGTo insert some details and a date. DG DGWhen I check the mysql database the

Re: Insert dates with PHP

2002-05-15 Thread Defryn, Guy
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

RE: Re: Insert dates with PHP

2002-05-15 Thread domi
Hi ! You said anything about connecting to mysql. You need to go through 2 steps before mysql_query(). These are mysql_connect() mysql_select_db() please check the URL below, everything is explained very clearly. http://www.php.net/manual/en/function.mysql-query.php You could also tell us