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 .
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
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
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