tables

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

plz help

Do you receive and errors?

Take this out, I'm not even sure what it is:

desc text,

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

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.