Re: what's wrong with this?????
| From: | Nadim Attari | Date: | Wed, 09 Jul 2003 07:11:13 +0000 |
| Subject: | Re: what's wrong with this????? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-154499@lists.php.net to get a copy of this message | ||
> $result = mysql_query('CREATE TABLE members (userid INT(25) NOT NULL
> AUTO_INCREMENT, first_name VARCHAR(30) NOT NULL, last_name VARCHAR(50) NOT
> NULL, email_address VARCHAR(255) NOT NULL, username VARCHAR(30) NOT NULL,
> password VARCHAR(30) NOT NULL, activated ENUM('0','1') DEFAULT
> '0' NOT
NULL,
> date_joined DATETIME NULL, last_login DATETIME NULL);')or die("Create
table
> Error: ".mysql_error());
---------------------------------------------------
- First of all verify ' (single quote) or " (double quote) here... this
should solve the problem
BUT
- Another problem will crop 'coz u didnot define a key...
Read
-----
PRIMARY KEY (index_col_name,...)