Try... $query = "INSERT INTO accounts (accnts,timestamp)
VALUES(''.$accnts[0].'','TIMESTAMP(10)')";

Might work?

Aaron



-----Original Message-----
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] 
Sent: November 20, 2002 2:16 PM
To: '[EMAIL PROTECTED]'
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:  [EMAIL PROTECTED]
Web:  http:\\ldsa.sbcld.sbc.com



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to