RE: [PHP-DB] INSERT question...

Try... $query = "INSERT INTO accounts (accnts,timestamp) VALUES(''.$accnts[0].'','TIMESTAMP(10)')"; Might work? Aaron -----Original Message----- From: NIPP, SCOTT V (SBCSI) [mailto:sn4265@sbc.com] Sent: November 20, 2002 2:16 PM To: 'php-db@lists.php.net' Subject: [PHP-DB] INSERT question... I have an INSERT statement that I cannot quiet get working. The table that this data is being put into has 7 columns, but I only care about putting in the data from the first two columns at this time. The first column is an array element, and the second column needs to be a timestamp. Here is the INSERT statement: $query = "INSERT INTO accounts VALUES('".$accnts[0]."', 'TIMESTAMP(10)', , , , ,)"; Here is the error being displayed on the web page: You have an error in your SQL syntax near ' , , ,)' at line 1 Thanks in advance for the help. Scott Nipp Phone: (214) 858-1289 E-mail: sn4265@sbc.com Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php