php timestamp newbie question - GoFuckYourself.com

mkx · 01-04-2006, 01:28 AM

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 · 01-04-2006, 01:32 AM

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 · 01-04-2006, 01:35 AM

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 · 01-04-2006, 01:36 AM

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

mkx · 01-04-2006, 01:37 AM

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 · 01-04-2006, 01:39 AM

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

the bold part shows the third row (timestamp)

mkx · 01-04-2006, 01:42 AM

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

01-04-2006, 01:28 AM	#1
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	php timestamp newbie question 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

01-04-2006, 01:32 AM	#2
grumpy Too lazy to set a custom title Join Date: Jan 2002 Location: Holland Posts: 9,870	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. ) __________________ Don't let greediness blur your vision \| You gotta let some shit slide icq - 441-456-888

01-04-2006, 01:35 AM	#3
Tempest Too lazy to set a custom title Industry Role: Join Date: May 2004 Location: West Coast, Canada. Posts: 10,217	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.

01-04-2006, 01:36 AM	#4
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	thats what i thought but i tried a test transaction and it showed up as "00000000000000"

01-04-2006, 01:37 AM	#5
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	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

01-04-2006, 01:39 AM	#6
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	$sqlquery = "INSERT INTO $table VALUES( '".mysql_insert_id()."',' 1',' ',' ',' ',' ',' the bold part shows the third row (timestamp)

01-04-2006, 01:42 AM	#7
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	ok nevermind, i see that when you update the transaction it changes. my program updates it before I need the timestamp anyways. Thanks!