INSERT wont work:

[Anon]

can someone tell me why this insert wont work:

the table is :
ID - INT AUTO PRIMARY UNIQUE
TITLE - TEXT
DATE - DATETIME
CAT_ID - VARCHAR
SUMMARY - TEXT
NEW - VARCHAR DEFAULT:YES
POST - VARCHAR DEFAULT:NO

here is the insert code:
INSERT INTO COLUMNS VALUES (NULL,'Hello there',NOW(),'5','summary','yes','no')

i keep getting false, any idea why?

[tomhath]

Can you run other SQL Queries? Could be a problem with the connection.

One other thing. I'd avoid using common words like "DATE", "NEW", "POST", and "COLUMNS" for table/column names. You risk colliding with reserved words in the language or DBMS. They also aren't very descriptive (or mnemonic, if you want to impress people).

[Anon]

yeah, I changed the table name from columns to editorials and the exact same query worked fine, thanks

[Anon]

The reason was because columns is a kind of reserved keyword.

Bill