View Single Post
Old November 26th, 2006, 10:47 PM   #16 (permalink)
ESAD
Member
 
Join Date: Sep 2006
Posts: 62
I get this error upon running that query

SQL query:

CREATE TABLE IF NOT EXISTS pp_favorites(

id int( 12 ) NOT NULL AUTO_INCREMENT ,
userid int( 8 ) NOT NULL default '0',
photo int( 11 ) NOT NULL default '0',
PRIMARY KEY ( id ) ,
KEY parent( photo ) ,
KEY userid( userid ) TYPE = MYISAM

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4
__________________
www.GigaThreads.com
ESAD is offline   Reply With Quote