Re: Insertion of integer in a database

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