CREATE TABLE " . iNA_GAMES . "(
`game_id` mediumint( 9 ) NOT NULL AUTO_INCREMENT ,
`cat_id` mediumint( 8 ) default NULL ,
`game_name` varchar( 25 ) default NULL ,
`game_path` varchar( 255 ) default NULL ,
`image_path` varchar( 255 ) default NULL ,
`game_desc` varchar( 255 ) default NULL ,
`game_charge` int( 11 ) unsigned default '0',
`game_reward` int( 11 ) unsigned NOT NULL default '0',
`game_bonus` smallint( 5 ) unsigned default '0',
`at_game_bonus` smallint( 5 ) default '0',
`game_use_gl` tinyint( 3 ) unsigned default '0',
`game_flash` tinyint( 1 ) unsigned NOT NULL default '0',
`game_show_score` tinyint( 1 ) NOT NULL default '1',
`game_avail` tinyint( 1 ) unsigned default '1',
`allow_guest` tinyint( 1 ) unsigned default '0',
`win_width` smallint( 6 ) NOT NULL default '0',
`win_height` smallint( 6 ) NOT NULL default '0',
`highscore_limit` int( 11 ) default NULL ,
`at_highscore_limit` int( 10 ) default '0',
`reverse_list` tinyint( 1 ) NOT NULL default '0',
`played` int( 10 ) unsigned NOT NULL default '0',
`instructions` text,
PRIMARY KEY ( `game_id` ) ,
`score_type` smallint( 1 ) default NULL ,
PRIMARY KEY ( `game_id` )
)
MySQL 傳回:
#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 '" . iNA_GAMES . "( `game_id` mediumint( 9 ) NOT NULL AUTO_
請問傳回值寫什麼東西??哪裡錯了嗎??
[問題]幫看SQL錯誤
版主: 版主管理群

