View Single Post
Old 06-23-2004, 12:14 PM   #11 (permalink)
metazai
Regular Contributor
 
Join Date: Apr 2004
Location: Orange County, CA
Posts: 124
metazai is on a distinguished road
Ok, here's from phpadmin:

Error

SQL-query :

CREATE TABLE 'Friday'(

'id'tinyint( 4 ) NOT NULL auto_increment,
'start_time'int( 11 ) NOT NULL default '0',
'end_time'int( 11 ) NOT NULL default '0',
'time_label'text NOT NULL ,
'name'text NOT NULL ,
'image'text NOT NULL ,
'info_link'text NOT NULL ,
PRIMARY KEY ( 'id' )
) TYPE = MyISAM

MySQL said:


You have an error in your SQL syntax near ''Friday' ('id' tinyint(4) NOT NULL auto_increment, 'start_time' int(11) NOT NULL' at line 1





And here's the echo:

CREATE TABLE 'Friday' ('id' tinyint(4) NOT NULL auto_increment, 'start_time' int(11) NOT NULL default '0', 'end_time' int(11) NOT NULL default '0', 'time_label' text NOT NULL, 'name' text NOT NULL, 'image' text NOT NULL, 'info_link' text NOT NULL, PRIMARY KEY ('id')) TYPE=MyISAMYou have an error in your SQL syntax near ''Friday' ('id' tinyint(4) NOT NULL auto_increment, 'start_time' int(11) NOT NULL' at line 1
metazai is offline   Reply With Quote