All pastes #16373 Raw Edit

Something

public text v1 · immutable
#16373 ·published 2005-06-29 18:09 UTC
rendered paste body
Table named processor, create it with this:

CREATE TABLE `processor` (
  `name` longtext NOT NULL,
  `brand` text NOT NULL,
  `frequency` int(4) NOT NULL default '0',
  `fsb` int(4) NOT NULL default '0',
  `socket` int(4) NOT NULL default '0',
  `other` longtext NOT NULL,
  `price` float NOT NULL default '0',
  `url` longtext NOT NULL
)

****************************
These are the values I currently have appended to it (if you are added more items, make sure to make each price higher than the one previous so the script on index.php works.  I have not made it so it sorts them yet.


INSERT INTO `processor` VALUES ('p1', 'p1', 1, 11, 111, 'o1', 11, 'uploads/');
INSERT INTO `processor` VALUES ('p2', 'b2', 2, 22, 222, 'o2', 22.2, 'uploads/noimg.png');
INSERT INTO `processor` VALUES ('p3', 'b3', 3, 33, 333, 'o3', 333.33, 'uploads/noimg.png');
INSERT INTO `processor` VALUES ('p4', 'b4', 4, 44, 444, 'o4', 444.44, 'uploads/');