What's Wrong With This??????

PHPBABY3 wrote:
> Error
> SQL query:
> INSERT INTO FORCE SET USERNUM = "2",
> BUYSELL = "S",
> PURCH = "5"
> MySQL said:
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'FORCE set USERNUM="2",BUYSELL="S",PURCH="5"' at line 1
>
> USERNUM int(11)
> BUYSELL char(1) latin1_swedish_ci
> PURCH int(11)

INSERT INTO `FORCE`(USERNUM,BUYSELL, PURCH) VALUES(2,'S',5)

Hints, use lower case names for your tables and columns.
Use better names for your tables and columns, don't use reserved words as
table or column names.
For id numbers, use UNSIGNED, this will give you double up the amount of users
you can have.

--

//Aho