Toy Posted August 31, 2010 Share Posted August 31, 2010 So I have a post form and I would want to be able to enter the same info twice or more but mysql just ignores it if I enter the same information in a column more than once, help Link to comment https://forums.phpfreaks.com/topic/212190-hmmhelp/ Share on other sites More sharing options...
petroz Posted August 31, 2010 Share Posted August 31, 2010 Make sure your column does not have unique indexing enabled on the columns that could contain duplicate info. Link to comment https://forums.phpfreaks.com/topic/212190-hmmhelp/#findComment-1105678 Share on other sites More sharing options...
Toy Posted August 31, 2010 Author Share Posted August 31, 2010 Make sure your column does not have unique indexing enabled on the columns that could contain duplicate info. how exactly do i do this? :S i'm using mysql Link to comment https://forums.phpfreaks.com/topic/212190-hmmhelp/#findComment-1105680 Share on other sites More sharing options...
petroz Posted August 31, 2010 Share Posted August 31, 2010 Are you using phpmyadmin? Link to comment https://forums.phpfreaks.com/topic/212190-hmmhelp/#findComment-1105681 Share on other sites More sharing options...
Toy Posted August 31, 2010 Author Share Posted August 31, 2010 Are you using phpmyadmin? Yes. Link to comment https://forums.phpfreaks.com/topic/212190-hmmhelp/#findComment-1105689 Share on other sites More sharing options...
petroz Posted August 31, 2010 Share Posted August 31, 2010 Goto phpmyadmin, open the structure of the table your having problems with. Then check the index section to see if some objects are set to Unique "Yes". If so, that might be your problem. Also, post your form, there might be another issue. [attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/212190-hmmhelp/#findComment-1105690 Share on other sites More sharing options...
Toy Posted August 31, 2010 Author Share Posted August 31, 2010 Goto phpmyadmin, open the structure of the table your having problems with. Then check the index section to see if some objects are set to Unique "Yes". If so, that might be your problem. Also, post your form, there might be another issue. they are indeed set to unique : yes, a total beginner question; how do i change this ? EDIT: nevermind, i just didnt see the pen button EDIT2: can't seem to find the option to set the unique to no? Link to comment https://forums.phpfreaks.com/topic/212190-hmmhelp/#findComment-1105695 Share on other sites More sharing options...
petroz Posted August 31, 2010 Share Posted August 31, 2010 Well.. You should keep some kind of primary key. I recommend having one column setup as your ID and have that set to autoincrement. Its not required though. For removing those indexes just click the delete button (Red X) on the index section of the column your having problems with. Link to comment https://forums.phpfreaks.com/topic/212190-hmmhelp/#findComment-1105697 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.