I don't think the integer is the problem, but if it is you can turn time() into a variable and then,

$time = time();



david joffrin wrote:

Hi folks,

Problem is fairly simple, but how can I insert integer in an SQL statement?

So, I only had strings, but now I have introduced a timestamp column (bigint to cover the milleseconds), and I have the following statement:
$queryInsert = "INSERT INTO mytables (..., timestamp) VALUES ('";
$queryInsert .= ...; // several columns
$queryInsert .= "', '";
$queryInsert .= time() . "')";
$result = mysql_query($queryInsert);


This is not working as time() returns an integer and .= only works with strings!

How can I cope with that?

Thanks.
DvJ


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



Reply via email to