I am looking at starting a pc game help site thats lists all know issues for pc games as well as which graphics cards, cpus, operating systems, driver versions these issues relate to.

 

I would like to build a database of these issues thats easily searchable. If you had an issue with say call of duty 2 and you had an 8800gtx gpu, q6600 cpu xp sp3 you would select

 

game drop down list: call of duty

 

os drop down list: xp sp3

 

gpu drop down list: Nvidia 8800gtx

 

etc etc

 

The results returned would go from most specific to least. So results realting to call of duty 2 8800 issues would come before other call of duty 2 issues for say 7800 gpus.

 

Is this easy enough to do under mysql? and is they an specific plugins, apps etc that are useful for this task?

 

Thanks

Is this easy enough to do under mysql? and is they an specific plugins, apps etc that are useful for this task?

 

Easiness will be a result of skill, experience, resourcefulness, intellect and other such factors.

As rallport said, you'll probably have to code it yourself though you might be able to find SQL table dumps of graphic card, processor and other component details to help build your database structure.

Tables:

 

CREATE TABLE `op_systems` (
`op_id` TINYINT( 2 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`op_name` VARCHAR( 40 ) NOT NULL
) AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `games` (
 `game_id` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
 `os_id` tinyint(2) unsigned NOT NULL,
 `game_name` varchar(40) NOT NULL,
 PRIMARY KEY (`game_id`),
 KEY `os_id` (`os_id`)
) AUTO_INCREMENT=1;