Re: Table creation problems...
| From: | Jason Wong | Date: | Sun, 09 Sep 2001 10:29:09 +0000 |
| Subject: | Re: Table creation problems... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12272@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: Jonathan Halterman <ilmaestro@jps.net>
To: <php-db@lists.php.net>; <php-general@lists.php.net>
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