----- Original Message -----
From: Jonathan Halterman <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, September 09, 2001 5:37 PM
Subject: [PHP-DB] Table creation problems...


> $result = mysql_db_query($db, "CREATE TABLE $groupid (`topicid` INT NOT
> NULL, `parentid` INT NOT NULL, `topic` TINYINT NOT NULL, `text` TEXT NOT
> NULL, `user` VARCHAR(20) NOT NULL, `lastactive` DATETIME NOT NULL,
`created`
> DATETIME NOT NULL, `posts` INT NOT NULL , PRIMARY KEY (`topicid`), UNIQUE
> (`topicid`))");

> Could someone please tell me how I can use a long type, such as a table ID
> as the name of another table?

try "CREATE TABLE '$groupid' ..."

hth
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
Tel: +852-2573-5033
Fax: +852-2573-5851




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to