Timestamp doesn't work

[seaminem]

$sql = "insert into member values ('','$RUname','$RPass','$RName','$RLastName','$RGender','$RDOB','$REmail','$RAddress','$RTel','$RShip','$RCredit','$RPoint','')";
		mysql_query($sql) or die ("cannot insert into member");

SQL ::
create table member
(user_id int primary key not null auto_increment,
username varchar(15) not null,
password varchar(15) not null,
name varchar(30) not null,
surname varchar(50) not null,
gender char(1) not null,
dob varchar(15) not null,
email varchar(30) not null,
address varchar(200) not null,
phoneno varchar(20) not null,
shipping_ad varchar(200) not null,
creditcardno varchar(16) not null,
collected_point int not null,
last_login timestamp not null);

The time stamp shows in sql is 0000000000000000000 ... It doesn't work.

[bpat1434]

No.... it does work... but it's default is 00000000000000....

If you want to insert a timestamp you need to use the mySQL functions in your query:

'$RPoint',NOW())"

Otherwise, you'll get no time-stamp and the default 0....

[seaminem]

still doesn't work

[seaminem]

It works now... Thank you.