CODE
select id,title,year,imdb,genre,poster,rating,actor,disc,quality,type,resx,resy,notes,r
elease,director from movies order by title ASC limit 0,10
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 'release,director from movies order by title ASC limit 0,10' at line 1
elease,director from movies order by title ASC limit 0,10
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 'release,director from movies order by title ASC limit 0,10' at line 1
mysql structure
CODE
CREATE TABLE `movies` (
`id` INT( 255 ) NOT NULL AUTO_INCREMENT ,
`imdb` VARCHAR( 7 ) NOT NULL ,
`title` VARCHAR( 155 ) NOT NULL ,
`genre` SET( 'Action', 'Adult', 'Adventure', 'Animation', 'Comedy', 'Crime', 'Documentary', 'Drama', 'Erotic', 'Family', 'Fantasy', 'Flim-Noir', 'Horror', 'Musical', 'Mystery', 'Romance', 'Sci-Fi', 'Short', 'Thriller', 'War', 'Western', 'other' ) DEFAULT 'other' NOT NULL ,
`year` YEAR( 4 ) DEFAULT '0000' NOT NULL ,
`poster` VARCHAR( 255 ) NOT NULL ,
`rating` CHAR( 3 ) NOT NULL ,
`actor` VARCHAR( 255 ) NOT NULL ,
`disc` INT( 2 ) NOT NULL ,
`quality` INT( 1 ) NOT NULL ,
`type` SET( 'ASF', 'DAT', 'DivX', 'DVD', 'M2V', 'MOV', 'MPEG', 'RAM', 'SVCD', 'VCD', 'WMV', 'XVCD' ) NOT NULL ,
`resx` VARCHAR( 4 ) ,
`resy` VARCHAR( 4 ) ,
`notes` TEXT,
`release` VARCHAR( 255 ) NOT NULL ,
`Director` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = MYISAM COMMENT = 'PMDB'
