MySQL insert problems

[paaaaaaaaaa]

Im having some problems with mySQL,

Ive been trying to INSERT a new record I know you have to do it like:

INSERT INTO artists (id, name, date, location)
VALUES ('', '$name', '$date', '$location')

This is the code im useing but an example, it normally works for me but not this time. So to do some debugging I made phpmyadmin pump out some php for an insert and it adds in two extra values like:

INSERT INTO artists (id, name, date, location)
VALUES ('', '$name', '$date', '','', NULL)

This works but when I tell the last value to be a variable the extra values move about so I just cant get it right. Anybody know whats going on here?

 

[user-7256]

if id is primary key, auto-increment, change '' to NULL.

 

[Kate]

If ID is primary key, auto-increment, there is not need to supply a value for that field...

 

[aween]

If ID is primary key, auto-increment, there is not need to supply a value for that field...

You took my words! :P :tu:

 

[Jamison54]

This should be the correct, and working code:

INSERT INTO `artists` (id, name, date, location) VALUES ('','$name','$date','$location');

paaaaaaaaaa, where you been?