david joffrin <mailto:david_joffrin@xxxxxxxxxxx> on Wednesday, March 23, 2005 1:01 PM said: > So, I only had strings, but now I have introduced a timestamp column > (bigint to cover the milleseconds) Why not use VARCHAR instead? Timestamp doesn't need to be numeric does it? For sure it's not required to be numeric. > and I have the following statement: > $queryInsert = "INSERT INTO mytables (..., timestamp) > VALUES ('"; $queryInsert .= ...; // several columns > $queryInsert .= "', '"; > $queryInsert .= time() . "')"; > $result = mysql_query($queryInsert); May I suggest the following? <?php $timestamp = time(); $queryInsert = <<<QQQ INSERT INTO mytables (columnA , columnB , ... , timestamp) VALUES ('$valueA' , '$valueB' , ... , $timestamp) QQQ; ?> HTH, Chris. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
