Posted by Joseph Connolly on 03/23/05 23:14

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
>

[Back to original message]