Hello,

When I try to mysql insert values with same names, it encourages this error. When I looked at the table column, I see that the row id is always "1" and it doesnt let to add same entry.



My question is, how can I add an auto increment id to that column for adding same entry names?

__________________
Downloadic
infolizer

If the field has an auto_increment attribute then you don't need to insert a value in that field. But using a COUNT query wouldn't return the id numbers, query your table like this (I am assuming your auto_increment query is aut_id):

My problem is, I can't add new user if the new user's firstname (aut_username) was used before.



I can add new column for firstname, but could you please tell me how to make it that lets you add same entry names.

__________________
Downloadic
infolizer

Can you show us your table structure? What your telling us doesn't seem right unless you have a problem with your structure.

__________________

It sounds like there's a PRIMARY or UNIQUE index on that column. Since you're using phpMyAdmin, click on the link at the bottom of the Structure tab that says 'Details'. Find the one for aut_username and change it from UNIQUE to INDEX.

GUI FTW. :)

__________________
uʍop ǝpısdn sı ɹǝʇndɯoɔ ɹnoʎ sıɥʇ pɐǝɹ uɐɔ noʎ ɟı

Thanks a lot, that works perfectly.

__________________
Downloadic
infolizer

I was only just starting my second pot of coffee when I wrote that, so you'll have to forgive the oversight; normally username columns are set to UNIQUE for a reason. You don't want two users with the same username, as you might run into a plethora of conflicts, not the least of which would be signing in.

__________________
uʍop ǝpısdn sı ɹǝʇndɯoɔ ɹnoʎ sıɥʇ pɐǝɹ uɐɔ noʎ ɟı