SQL Statement

[chillman87]

Hello i wanted to ask about running and sql statement. It keeps giving me errors like this:

Parse error: syntax error, unexpected T_STRING in C:\Documents and Settings\User\Desktop\php admin\phpMyAdmin-2.8.0.2\php46.tmp on line 46

This is the statment that I am trying to run:

$sql = 'CREATE TABLE' users ( <-- This is line 46
userid int(25) NOT NULL auto_increment,
first_name varchar(25) NOT NULL default '',
last_name varchar(25) NOT NULL default '',
email_address varchar(25) NOT NULL default '',
username varchar(25) NOT NULL default '',
password varchar(255) NOT NULL default '',
info text NOT NULL,
user_level enum('0','1','2','3') NOT NULL default '0',
signup_date datetime NOT NULL default '0000-00-00 00:00:00',
last_login datetime NOT NULL default '0000-00-00 00:00:00',
activated enum('0','1') NOT NULL default '0',
PRIMARY KEY (userid)
) TYPE=MyISAM COMMENT='Membership Information';

I placed this code into the "db_create.php" from "phpMyAdmin-2.8.0.2" I also want to know if that is the right code to run a SQL statement.

All and any help is appreciated thanks. 🙂

[Houdini]

Change this;

$sql = 'CREATE TABLE' users ( <-- This is line 46 acutally all of that query is on one line
userid int(25) NOT NULL auto_increment,
first_name varchar(25) NOT NULL default '',
last_name varchar(25) NOT NULL default '',
email_address varchar(25) NOT NULL default '',
username varchar(25) NOT NULL default '',
password varchar(255) NOT NULL default '',
info text NOT NULL,
user_level enum('0','1','2','3') NOT NULL default '0',
signup_date datetime NOT NULL default '0000-00-00 00:00:00',
last_login datetime NOT NULL default '0000-00-00 00:00:00',
activated enum('0','1') NOT NULL default '0',
PRIMARY KEY (userid)
) TYPE=MyISAM COMMENT='Membership Information';

to this and it will work.

$sql = mysql_query("CREATE TABLE users ( 
userid int(25) NOT NULL auto_increment,
first_name varchar(25) NOT NULL default '',
last_name varchar(25) NOT NULL default '',
email_address varchar(25) NOT NULL default '',
username varchar(25) NOT NULL default '',
password varchar(255) NOT NULL default '',
info text NOT NULL,
user_level enum('0','1','2','3') NOT NULL default '0',
signup_date datetime NOT NULL default '0000-00-00 00:00:00',
last_login datetime NOT NULL default '0000-00-00 00:00:00',
activated enum('0','1') NOT NULL default '0',
PRIMARY KEY (userid)
) TYPE=MyISAM COMMENT='Membership Information'");

[Sxooter]

Please note that color coding this revealed this error in seconds.

[chillman87]

thanks