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
