Anytime I use the simple INSERT statement to add a row to my table, row is added twice to the DB table:

INSERT INTO table_name VALUES
(value1, value2, value3);

I don't know'hat's wrong self.

Cc:
dhtm18, larisoft, et al...

Post your real code

The code snippet you provided will most likely not even insert into the database as it is incomplete.

Possible causes could be:
You typed in the Insert statement twice,
Or you got your code mixed up somewhere,
But the cause cannot be from thE Database, it should be the queries that are faulty.., Provide your code in a more detailed way, If you want to hide sensitive info just replace it with example names that don't really exist in your Production/Development environment.

DanielTheGeek:
The code snippet you provided will most likely not even insert into the database as it is incomplete.

Possible causes could be:
You typed in the Insert statement twice,
Or you got your code mixed up somewhere,
But the cause cannot be from thE Database, it should be the queries that are faulty.., Provide your code in a more detailed way, If you want to hide sensitive info just replace it with example names that don't really exist in your Production/Development environment.

bros, all other statements works fine, except the INSERT statement.
I am just testing somethings out.
Table looks like:


CREATE TABLE tblCustomerDetails (
cutomerID INT(11) PRIMARY KEY AUTO_INCREMENT,
surname VARCHAR(30) NOT NULL,
lastname VARCAHR(30) NOT NULL,
);


now, when I use the UI provided by phpmyadmin (XAMPP) to enter values for a new row, it works fine. But when I write mysql code to enter a SINGLE row(of values), it adds double row to the table. It's really messing up my PK seqence. Bros, I dey check my sql statement wella, double check am self, still its 'malfunctioning'.
I am only working with SQL syntaxes. No PHP or any other language, just SQL.

The only reason why you are experiencing this is maybe cos your sql statement is enclosed in a loop or your browser is sending same information twice.

How are you sending your request? Is it thru ajax or normal POST/GET request?

You can paste the code you are using that's making the error for further scrutiny.

Regards

Did you open and close ur php tag properly...
Maybe you should also end database query .

You can post it to my signature, gurus are available all time...
Am not good at this aspect, learning continue

incredible6:
Did you open and close ur php tag properly...
Maybe you should also end database query .

bros, no other code collaboration, just MySQL. Do you get that? No PHP, no other code, just SQL!

The SQL INSERT ....... VALUES( ) code creates two rows instead of one!
Funny thing is that, when I used the UI provided in PhpMyAdmin (XAMPP, windows) to add a new row to the same table, it adds just a row! I don confuse die.

The correct syntax should be:
"INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3)"
Where value1, value2 and value3 = integer or character.

Silverman42:
The correct syntax should be:
"INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3)"
Where value1, value2 and value3 = integer or character.

His syntax is valid. You are not always required to specify the column names.

@ paranorman

noordean:
Post your real code

Let us see the code that is not working properly.

Silverman42:
The correct syntax should be:
"INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3)"
Where value1, value2 and value3 = integer or character.

Thumbs up for 'best practice'.

@ OP:
If the SQL executes perfectly in phpMyAdmin, that is, once, then you're making two insert statements in your original script.

If you're using PHP, for instance, note the line number of the SQL in your text editor.
Now go up to the beginning of your script to check for any similar calls.

But here are my presumptions:
You might have created a function having that SQL and you changed the content of the same function. However, you're calling that function twice.
You might have created a loop(whatever for, as that would be absurd).

One thing is certain, you're using insert statement twice.