sql blues
| From: | Cybercandy Ltd | Date: | Sat, 02 Dec 2000 19:26:49 +0000 |
| Subject: | sql blues | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-28383@lists.php.net to get a copy of this message | ||
Please can someone tell me what I'm doing wrong in the sql (mysql) below:
$sql = "CREATE TABLE emailreg2 (
dateandtime timestamp(14),
email varchar(80) NOT NULL,
name varchar(80) NOT NULL,
openclosed varchar(10) NOT NULL DEFAULT 'open'
urn int(9) unsigned zerofill NOT NULL DEFAULT 000000000
AUTO_INCREMENT,
UNIQUE IDX_urn (urn)
)";
I know (i thing) it's something to do with the urn, but I just can't figure
it.
Allan
Cybercandy