dmraquel Posted November 25, 2012 Share Posted November 25, 2012 Hello guys, I'm trying to make this table to add to my website... www.icylips.co.uk in the MEMBERSHIP area I created a form and I'm trying to conect the form with the mysql to get a database. But I'm having this problem attached. Link to comment https://forums.phpfreaks.com/topic/271163-problems-with-tables/ Share on other sites More sharing options...
Pikachu2000 Posted November 25, 2012 Share Posted November 25, 2012 You cut off the most important part of it: the error message. Link to comment https://forums.phpfreaks.com/topic/271163-problems-with-tables/#findComment-1395042 Share on other sites More sharing options...
dmraquel Posted November 26, 2012 Author Share Posted November 26, 2012 Sorry, this is a new one Link to comment https://forums.phpfreaks.com/topic/271163-problems-with-tables/#findComment-1395070 Share on other sites More sharing options...
Pikachu2000 Posted November 26, 2012 Share Posted November 26, 2012 You need to grant the user CREATE privileges on that particular database, or log in with an account that has the CREATE privilege. Link to comment https://forums.phpfreaks.com/topic/271163-problems-with-tables/#findComment-1395071 Share on other sites More sharing options...
dmraquel Posted November 26, 2012 Author Share Posted November 26, 2012 when I try directly trough Myadmin he problem is another one.. Link to comment https://forums.phpfreaks.com/topic/271163-problems-with-tables/#findComment-1395185 Share on other sites More sharing options...
Pikachu2000 Posted November 26, 2012 Share Posted November 26, 2012 You've posted three different queries in this thread, with different errors. The first and third, your syntax appears wrong for the SET type field, and also in the third, you're trying to create `id` twice. The second one was a permissions issue, but I guess you've fixed that. MySQL SET syntax Link to comment https://forums.phpfreaks.com/topic/271163-problems-with-tables/#findComment-1395194 Share on other sites More sharing options...
dmraquel Posted November 27, 2012 Author Share Posted November 27, 2012 Yes, I really don't know what type I should replace set, because, the gender has the radio to chose between man and woman... What should I use in place of SET? Link to comment https://forums.phpfreaks.com/topic/271163-problems-with-tables/#findComment-1395395 Share on other sites More sharing options...
Pikachu2000 Posted November 27, 2012 Share Posted November 27, 2012 If there are only two options, you can either use ENUM, or just set it up as TINYINT and pick 1 for one gender and 0 for the other. Link to comment https://forums.phpfreaks.com/topic/271163-problems-with-tables/#findComment-1395406 Share on other sites More sharing options...
fenway Posted November 30, 2012 Share Posted November 30, 2012 ENUM is the way to go, if you insist of such column types. Link to comment https://forums.phpfreaks.com/topic/271163-problems-with-tables/#findComment-1396369 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.