Q:

MySQL INSERT problem

Does anyone know what is problem with this query:
INSERT INTO match 
  (IDTeamHome, IDTeamGuest, Date) 
VALUES 
  ('15','16','20.03.2011 15:00')

IDTeamHome and IDTeamGuest are integer, and Date is varchar.

A:

Edit: there are several issues.  

"match" and "date" are keywords in MySQL. You need double-quotes or backticks around them so that MySQL knows that they are table or column names, e.g.
INSERT INTO "match" (id1, id2, "date") VALUES ...
Remove the single-quotes around the integer values you're inserting.
Single-quotes are for strings. (not strictly necessary as pointed out by OMG Ponies in the comments)
If you can avoid it, do not store timestamps as VARCHAR. This will make querying more difficult and confuse anyone else who's working with your table(s).

