Umm quotes.
Anywhere in your actual SQL that you are using a single quote,
you need to put a backslash before it, example:
activated ENUM('0','1') DEFAULT '0'
Becomes:
activated ENUM(\'0\',\'1\') DEFAULT \'0\'
On Tue, 2003-07-08 at 11:26, Artoo wrote:
> I keep getting Parse error: parse error, unexpected T_LNUMBER in
> /usr/local/psa/home/create.php on line 9
>
> This is line 9, which should just create a table.
>
> $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());
>
> What's that error mean and is that CREATE TABLE query correct?
>
> Thanks
--
Adam Voigt ([EMAIL PROTECTED])
Linux/Unix Network Administrator
The Cryptocomm Group
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
