Sql Error

[dlc2000]

sorry i get this error when i send a query, what's wrong?:

You have an error in your SQL syntax near 'INSERT INTO liste_domaines VALUES( 1, 'ac', 'Isole di Ascensione')
INSERT INTO ' at line 2

the first lines of the quey are:

CREATE TABLE liste_domaines (id int(11) NOT NULL auto_increment,domaine char(20) NOT NULL,description char(50) NOT NULL,PRIMARY KEY (id))
INSERT INTO liste_domaines VALUES( '1', 'ac', 'Isole di Ascensione')

[merkinmuffley]

you can't do 2 queries at once, I believe. you need to perform the CREATE TABLE query by itself, then each INSERT query by itself, etc

[dlc2000]

yes so it work but why i can't insert more value so?

INSERT INTO liste_domaines VALUES( '1', 'ac', 'Isole di Ascensione')
INSERT INTO liste_domaines VALUES( '2', 'ad', 'Andorra')
INSERT INTO liste_domaines VALUES( '3', 'ae', 'Emirati Arabi Uniti')
INSERT INTO liste_domaines VALUES( '4', 'af', 'Afghanistan')
INSERT INTO liste_domaines VALUES( '5', 'ag', 'Antigua and Barbuda')

[merkinmuffley]

yes so it work but why i can't insert more value so?

sorry, you're going to have to elaborate... I have no idea what that means. are you asking why you can't make 2 records with 1 call to mysql_query()?

[dlc2000]

i mean that i have this sql file for a php script, why i can't send it and i must receive the error?

the sql file is:

CREATE TABLE liste_domaines (id int(11) NOT NULL auto_increment,domaine char(20) NOT NULL,description char(50) NOT NULL,PRIMARY KEY (id))
INSERT INTO liste_domaines VALUES( '1', 'ac', 'Isole di Ascensione')
INSERT INTO liste_domaines VALUES( '2', 'ad', 'Andorra')
INSERT INTO liste_domaines VALUES( '3', 'ae', 'Emirati Arabi Uniti')
INSERT INTO liste_domaines VALUES( '4', 'af', 'Afghanistan')
INSERT INTO liste_domaines VALUES( '5', 'ag', 'Antigua and Barbuda')
INSERT INTO liste_domaines VALUES( '6', 'ai', 'Anguilla')
INSERT INTO liste_domaines VALUES( '7', 'al', 'Albania')
INSERT INTO liste_domaines VALUES( '8', 'am', 'Armenia')
INSERT INTO liste_domaines VALUES( '9', 'an', 'Antille Olandesi')
INSERT INTO liste_domaines VALUES( '10', 'ao', 'Angola')

etc etc

[merkinmuffley]

I still don't understand... are you trying to open this file using a PHP script, then run the queries using PHP?

Or, are you just trying to run this script directly in mysql? If that's the case then you probably just need a semicolon at the end of each statement.

[dlc2000]

yes i am sending the sql file from phpmyadmin

thx

[merkinmuffley]

you need to learn how to ask a question and give the relevant information... don't you think that your original question should have included something like "I am trying to use phpmyadmin to do ______________" ?

sorry, but I have no idea what phpmyadmin does, so I'm afraid I can't help you. and unless you learn to clearly state your question, I doubt anybody can help you.