CREATE TABLE ranks (
ranking int(11) NOT NULL auto_increment,
title varchar(50) NOT NULL default '',
rendered varchar(255) NOT NULL default '',
rankorder int(11) NOT NULL default '0',
PRIMARY KEY (ranking)
) TYPE=MyISAM;
INSERT INTO ranks VALUES (1,'1 - Wouldn\'t mind it','',1);
INSERT INTO ranks VALUES (2,'2 - Would be nice to have','',2);
INSERT INTO ranks VALUES (3,'3 - Would make me happy','',3);
INSERT INTO ranks VALUES (4,'4 - I would really, really like this','',4);
INSERT INTO ranks VALUES (5,'5 - I\'d love to get this','',5);
UPDATE items SET ranking = 1;