php timestamp newbie question

[mkx]

ok i inserted a timestamp row and when i insert a new query manually from phpadmin it appears correctly. what command do i use for:

$sqlquery = "INSERT INTO $table
VALUES(
'".mysql_insert_id()."','
1','
???????????','
','
','
','



???????????',' is where the timestamp command should go

[grumpy]

you dont put anything in the timestamp. It will update automaticly when you update the record. So you leave that field empty. ( doesnt matter what you put there, it wont be accepted. )

[Tempest]

Was that field defined as a TIMESTAMP field? If so, then setting it to NULL will load it with the current time. You CAN set it to a specific value and it also updates every time the row is updated.

[mkx]

thats what i thought but i tried a test transaction and it showed up as "00000000000000"

[mkx]

yes it was put as NULL, when I update something via phpmyadmin it is fine, but when i insert it using the code in the 1st post, it shows up as all 0's

[mkx]

$sqlquery = "INSERT INTO $table
VALUES(
'".mysql_insert_id()."','
1','
','
','
','
','

the bold part shows the third row (timestamp)

[mkx]

ok nevermind, i see that when you update the transaction it changes. my program updates it before I need the timestamp anyways. Thanks!