Re: [PHP-DB] Insterting date in an MySQL table

2004-05-06 Thread John W. Holmes
From: "charalambos nicolaou" <[EMAIL PROTECTED]> > I want to created a MYSQL table which will get the date in the form > (-MM-DD) automatically. I have created the table below but it doesn't > get the form of date that I want. It has the form (MMDDHHMMSS) > > CREATE TABLE questions1 (ID IN

[PHP-DB] Insterting date in an MySQL table

2004-05-06 Thread charalambos nicolaou
Hi everyone, I want to created a MYSQL table which will get the date in the form (-MM-DD) automatically. I have created the table below but it doesn’t get the form of date that I want. It has the form (MMDDHHMMSS) CREATE TABLE questions1 (ID INT NOT NULL AUTO_INCREMENT,name VARCHAR(30),da