I have a unique problem with my phpmyadmin. For eg whenever I create a table with 2 fields and save the table, I end up getting this :

ERROR:

CREATE TABLE `test` (

`tst1` VARCHAR( 4 ) NOT NULL ,
`tst2` VARCHAR( 5 ) NOT NULL ,
`tst1` VARCHAR( 4 ) NOT NULL ,
`tst2` VARCHAR( 5 ) NOT NULL
) TYPE = MYISAM

MySQL said:

#1060 - Duplicate column name 'sdg'

I initially thought it was my phpmyadmin was an issue. So I replaced it with another phpmyadmin of a another server. But it still showed the same thing..

Anybody out there with a solution...Pls help???

Well I don't know phpmyadmin but just looking at you code it
appears that you are trying to create a table with FOUR fields.
Two of the fields are called tst1 and two of them are called
tst2. Field or column names must be unique. Maybe I am wrong,
please explain? Post your code not just the error message.

cant have a table with the same name, ie tst1 and tst1
try different names

Guys am sorry for not posting the complete table that I created. I know you cannot have duplicate names in a table. I create it like this

CREATE TABLE `test` (

`tst1` VARCHAR( 4 ) NOT NULL ,
`tst2` VARCHAR( 5 ) NOT NULL) TYPE = MYISAM

But when I save it in phpmyadmin it shows something like this:

MYSQL ERROR:

CREATE TABLE `test` (

`tst1` VARCHAR( 4 ) NOT NULL ,
`tst2` VARCHAR( 5 ) NOT NULL ,
`tst1` VARCHAR( 4 ) NOT NULL ,
`tst2` VARCHAR( 5 ) NOT NULL
) TYPE = MYISAM

MySQL said:

#1060 - Duplicate column name 'tst1'

Its very weird since it duplicates all the columns that I create in the table. However when I create the table from the mysql prompt its fine. Anybody with help and suggestions...??