DB Create Table help - using Pear DB
| From: | Scott Heinrichs | Date: | Wed, 12 Jul 2006 00:05:37 +0000 |
| Subject: | DB Create Table help - using Pear DB | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-239329@lists.php.net to get a copy of this message | ||
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.