View Single Post
  #1 (permalink)  
Old 08-01-03, 09:08 PM
kenfused kenfused is offline
Newbie Coder
 
Join Date: Aug 2003
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
MySQL with PHP question. HELP for a newbie

In trying to setup a MySQL database thru phpMyAdmin (a "SITEMAPPER" script from HOTSCRIPTS...)

I entered the SQL txt text into the MySQL commands:

SQL-query : [Edit]

CREATE TABLE /*!32300 IF NOT EXISTS*/ section (
sectionID int(3) NOT NULL auto_increment,
parentID int(3) NOT NULL DEFAULT \'0\' ,
title varchar(255) NOT NULL DEFAULT \'\' ,
content text ,
PRIMARY KEY (sectionID),
INDEX title (title)
);

MySQL said:


You have an error in your SQL syntax near '\'0\' ,
title varchar(255) NOT NULL DEFAULT \'\' ,
content text ,
PRIMA' at line 3


Does anyone know what the error is?
What does it mean?
Thanks
Reply With Quote