Pambos Nicolaou wrote:
I have created the table below:
CREATE TABLE questions (ID INT NOT NULL AUTO_INCREMENT,name
VARCHAR(30),day TIMESTAMP, question TEXT, email VARCHAR(30),answer TEXT,
PRIMARY KEY(ID));
I want to insert into the TIMESTAMP field the date automatically. How
can I do it
I want to insert into the TIMESTAMP field the date
automatically. How can I
do it using the insert command
INSERT INTO $table
VALUES('','$name','TIMESTAMP','$question','$email','NULL');
Use the word null (no quotes) in place of 'TIMESTAMP':
INSERT INTO $table
VALUES('', '$name',