Quoting "NIPP, SCOTT V (SBCSI)" <sn4265@sbc.com>:
> 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
I believe you will need to specify the target columns, and don't attempt to use
comma delimited nothings! ;-)
Example:
INSERT INTO accounts (col1, col2) VALUES ('val1', 'val2')
--
Ryan T. Gallagher
ryan@studiesabroad.com
International Studies Abroad
http://www.studiesabroad.com
(512)480-8522
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
