[PHP-DB] Inserting date into a table

[Pambos Nicolaou]

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 the  insert command

"INSERT INTO $table 
VALUES('','$name','TIMESTAMP','$question','$email','NULL')";

Thanks in advance

Pambos Nicolaou

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Advertising