sql error, NULL??

Question

So I have a query, can someone let me know if it looks ok content wise?

"INSERT INTO ".TBL_MESSAGES." (NULL, 'Your ranking points have changed', 
                                       'Due to your recent activity, your ranking points have increased by $r', '2', '$u', 
                                       '0', '0', '0', '0', NULL, NULL, NULL, NULL, now())";

I can add further information if the query doesnt appear to have a problem? Thanks

Answer 1

Usually an insert statement is of the form INSERT INTO [table name] ([list of field names]) VALUES ([list of values]). I don't know what variant of SQL you're using so maybe it doesn't matter...

Answer 2

Only thing I can think of is it looks like you're missing the keyword VALUES. Not sure what flavor of SQL you're using though...