View Single Post
Old 03-16-2011, 11:20 PM  
Danmixz
Confirmed User
 
Industry Role:
Join Date: Sep 2010
Posts: 649
Mysql can't figure it out :((

I made some modification to a tube script to add a Pornstar section, now i want to modified it to add more info... But seem i'm always getting some syntax error

Working Table:

PHP Code:
CREATE TABLE IF NOT EXISTS `pornstar` (  `PSIDbigint(20NOT NULL auto_increment,  `namevarchar(120NOT NULL default '',  `websitetext NOT NULL,  `viewsint(11NOT NULL,  `heighttext NOT NULL,  `hairtext NOT NULL,  `borntext NOT NULL,  `measurementstext NOT NULL,  `relatedtext NOT NULL,  `total_videosbigint(20NOT NULL default '0',  `abouttext NOT NULL,  `imagestext NOT NULL,  PRIMARY KEY  (`PSID`),  UNIQUE KEY `name` (`name`)) ENGINE=INNODB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 
What i'm trying to add:
PHP Code:
`performertext NOT NULL, `astrologytext NOT NULL, `birthplacetext NOT NULL, `yearstext NOT NULL, `weighttext NOT NULL, `ethnictext NOT NULL,`measurementstext NOT NULL
Any tips on this, seem i can't figure it out

Thanks!!!
__________________
Danmixz is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote