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. Quote 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. Quote 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 Quote 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. Quote 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.. Quote 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 (edited) 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 Edited November 26, 2012 by Pikachu2000 Quote 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? Quote 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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/271163-problems-with-tables/#findComment-1396369 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.