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 using
> 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('', '$n
