help me please Posted June 5, 2009 Share Posted June 5, 2009 hi my install.php creates two tables ( supposed to be three ). so i have to create the other one, but its realy hard to understand so can some1 please help heres the script part. mysql_query("CREATE TABLE banned (ip varchar(255) NOT NULL,reason varchar(255) NOT NULL,id int(11) NOT NULL auto_increment,PRIMARY KEY (id))"); //creates this one mysql_query("CREATE TABLE users (uname varchar(255) NOT NULL,pass varchar(255) NOT NULL,id int(11) NOT NULL auto_increment,PRIMARY KEY (id))"); //creates this one mysql_query("CREATE TABLE servers (name varchar(255),port varchar(255),desc text,pass varchar(255), ip varchar(255), ip2 varchar(255), id int(11) auto_increment,PRIMARY KEY (id))"); ^^^^^^ need help making this table thanks Quote Link to comment https://forums.phpfreaks.com/topic/161043-tables/ Share on other sites More sharing options...
help me please Posted June 5, 2009 Author Share Posted June 5, 2009 plz help Quote Link to comment https://forums.phpfreaks.com/topic/161043-tables/#findComment-849884 Share on other sites More sharing options...
Maq Posted June 5, 2009 Share Posted June 5, 2009 Do you receive and errors? Take this out, I'm not even sure what it is: desc text, Quote Link to comment https://forums.phpfreaks.com/topic/161043-tables/#findComment-849981 Share on other sites More sharing options...
kickstart Posted June 5, 2009 Share Posted June 5, 2009 Take this out, I'm not even sure what it is: desc text, Creating a text field called desc. Personally I would avoid any field names which are SQL used words, and in that case I would try surrounding desc with back ticks (`desc`). All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/161043-tables/#findComment-849987 Share on other sites More sharing options...
Maq Posted June 5, 2009 Share Posted June 5, 2009 Take this out, I'm not even sure what it is: desc text, Creating a text field called desc. Personally I would avoid any field names which are SQL used words, and in that case I would try surrounding desc with back ticks (`desc`). All the best Keith Right, for some reason I thought he was trying to do something else... "desc" is a reserved word so that is probably your problem, it would be nice if you posted the error. Quote Link to comment https://forums.phpfreaks.com/topic/161043-tables/#findComment-849991 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.