Re: DB Create Table help - using Pear DB

Scott Heinrichs wrote:

Hello all, This is the first time I have posted an issue to this forum, so please excuse in noob questions or statement. I am trying to create a table from a string that created by a DESCRIBE TABLE query... this is the generated string: CREATE TABLE 'users' ( 'username' varchar(120) NOT NULL primary key, 'password' varchar(64) NOT NULL, 'level' int(11) NOT NULL DEFAULT '0' ) then I use the statement: $db is a PEAR DB object that has been set up with my database access info and connects to MYSQL. $stmt = above create string. $db->query ( $stmt ); for some reason it is not creating the desired table. Can anyone give me a solution or a reason why the above situation would not work. Just to clarify that my Database info is correct I was able to generate the create string from a DESCRIBE TABLE query so the connection works and is valid and I have CREATE rights. is an error being generated? if so what does it say?

-- life is a game... so have fun.