Mr_J Posted September 8, 2008 Share Posted September 8, 2008 Hi all, So I couldn’t get Apache to work last week... I didn’t understand it seems like MySQL: I have on my server cPanel a phpMyAdmin to control (conf.inc.php) I have a TableName: PhMail_User (15) fields My PROBLEM is the following values: Field: User_ID Comments Type: ??(INT or VARCHAR or TINYINT etc.) Length/Values1: 10 (I assume the no of chars) Collation: ??? Attributes: ??? (Binary, Unsigned etc.) Null: NotNull (Null) Default2: ??? Extra: Auto_increment (for use of server assigned - I think) Primary or Index or Unique or ---:??? Comments: creator comments I assume... I tried to add about 10 fields, when I "save" I get a MySQL ERROR witch I do not understand at all Can anyone maybe explain a bit more about the "fields" to me? Regards Jaco Quote Link to comment https://forums.phpfreaks.com/topic/123249-phpmyadmin/ Share on other sites More sharing options...
JonnoTheDev Posted September 8, 2008 Share Posted September 8, 2008 post the error Quote Link to comment https://forums.phpfreaks.com/topic/123249-phpmyadmin/#findComment-636499 Share on other sites More sharing options...
Mr_J Posted September 8, 2008 Author Share Posted September 8, 2008 post the error I did it again, the same as last time and this is the result... CREATE TABLE `phMailList_db`.`PhMail_User` ( `ID_No` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `List_Type` TEXT NOT NULL , `email_adr` TEXT NOT NULL , `psw` TEXT NOT NULL , `Acc_No` TEXT NOT NULL , `Name` TEXT NOT NULL , `Adres` TEXT NOT NULL , `Tel_Werk` TEXT NOT NULL , `Tel_Mobile` TEXT NOT NULL , `M_F` TEXT NOT NULL ) ENGINE = MYISAM Quote Link to comment https://forums.phpfreaks.com/topic/123249-phpmyadmin/#findComment-636516 Share on other sites More sharing options...
JonnoTheDev Posted September 8, 2008 Share Posted September 8, 2008 There is no error here. This is the create table command Quote Link to comment https://forums.phpfreaks.com/topic/123249-phpmyadmin/#findComment-636523 Share on other sites More sharing options...
revraz Posted September 8, 2008 Share Posted September 8, 2008 Go to the MySQL webpage and look at the CREATE TABLE command. Quote Link to comment https://forums.phpfreaks.com/topic/123249-phpmyadmin/#findComment-636529 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.