time stamp problems

miles_rich

Maybe somone could help me with a few problems i have with the time stamp function.

when you call a time stamp it adds a timestamp yes?? so why when i do it is just get 0's?? do i have to set the time on the mysql server or what?? someone help!!!

FuXs

can u show us your code please?

miles_rich


<?php





	if (isset($hostname) and isset($database) and isset($db_login) and isset($db_pass))
 {  


$dbconn = mysql_connect($hostname, $db_login, $db_pass) or die("ERROR : Could not connect");  
//print "<div align='left'>Connected to host.<br>";

mysql_select_db($database) or die("ERROR : Could not select database");   
//echo "Database selected.<br>";

$query = "INSERT INTO aq_info (cust_name, cust_road, cust_city, cust_post, cust_telone, cust_teltwo, cust_fax, comp_name, comp_road, comp_city, comp_post, comp_telone, comp_teltwo, comp_fax, stamp) VALUES ('$custname', '$custroad', '$custcity', '$custpost', '$custtelone', '$custteltwo', '$custfax', '$compname', '$comproad', '$compcity', '$comppost', '$comptelone', '$compteltwo', '$compfax', 'timestamp')";
$result = mysql_query($query) or die("ERROR : Query failed");       
echo "<B>Customer details added to database.</B><br>";

mysql_close($dbconn);                                
//echo "<right><FORM><INPUT TYPE='BUTTON' VALUE='Next' ONCLICK='history.go(-1)'></FORM></right>";
die;



}


?>

malbera

$timestamp=time();
$query = " insert into table (field1,... ,timestamp) values ('$value1',...,'$timestamp');

hope that helps

yelvington

"INSERT INTO aq_info (stamp) VALUES ('timestamp')";

This inserts a string literal into a column that presumably is defined as something else.

FuXs

u can live the field stamp empty because mySql will write it automatical into the table

miles_rich

i know that but i just get 00-00-00 etc...

how do i set the time on amysql server??

mrmufin

If the column type is TIMESTAMP, you can just use the MySQL NOW() function:

$query = "INSERT INTO aq_info (cust_name, cust_road, cust_city, cust_post, cust_telone, cust_teltwo, cust_fax, comp_name, comp_road, comp_city, comp_post, comp_telone, comp_teltwo, comp_fax, stamp) VALUES ('$custname', '$custroad', '$custcity', '$custpost', '$custtelone', '$custteltwo', '$custfax', '$compname', '$comproad', '$compcity', '$comppost', '$comptelone', '$compteltwo', '$compfax', NOW())";

If the column type is INT, you can use the PHP time() function, since time() returns an integer representing the current UNIX time:

$query = "INSERT INTO aq_info (cust_name, cust_road, cust_city, cust_post, cust_telone, cust_teltwo, cust_fax, comp_name, comp_road, comp_city, comp_post, comp_telone, comp_teltwo, comp_fax, stamp) VALUES ('$custname', '$custroad', '$custcity', '$custpost', '$custtelone', '$custteltwo', '$custfax', '$compname', '$comproad', '$compcity', '$comppost', '$comptelone', '$compteltwo', '$compfax', time())";

Bobbo

I'd just like to say that I spent the better half of an hour wondering why the timestamp wouldn't get entered into the database (just getting 0000000)

I was inserting the time() like "INSERT VALUES('time()');" instead of "INSERT VALUES(time());"

I was wrapping time() in apostrophe's which is a bad bad idea

Thanks everyone