----- 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]