wrong syntax

[urgido]

I tried to executed the below code, but something is wrong, Can somebody tell me what's wrong?

PHP Code:

INSERT INTO country VALUES (1, 'AE');
INSERT INTO country VALUES (2, 'AF');
INSERT INTO country VALUES (3, 'AG'); 


[mic2100]

when ever i do an insert i first define which fields the data is going to be written to. Like this...

INSERT INTO country (id, country) VALUES (1, 'AE'); 
INSERT INTO country (id, country) VALUES (2, 'AF'); 
INSERT INTO country (id, country) VALUES (3, 'AG');

[urgido]

error:

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 '; INSERT INTO country (id, country) VALUES (6, 'AL')' at line 1

[mic2100]

is bm60_staaten the name of ur table where all the countries are stored???

[mic2100]

did it enter the values before this into the db if so i could be a problem with that specific INSERT statement????

[Kid Charming]

Are you sending all three queries through one PHP mysql_query() call, by chance?

[urgido]

sorry I edit and save the changes. The name is Country the other name is based on helo in other forum. hehehe