Guest Posted March 6, 2003 Posted March 6, 2003 Hi, Does anybody know how to add more categories to the custom computer addon? I have tried but cant seem to get it to work. I need to add about 10 more categories. Can anyone help me with this? Thanks
Guest Posted March 7, 2003 Posted March 7, 2003 Looks like you would alter the db by doing either a sql statement or going to phpadmin and doing it manually. for sql file something like ALTER TABLE products ADD Thingy1varchar(30) NOT NULL default '', ADD Thingy2 varchar(30) NOT NULL default ''; INSERT INTO ccc VALUES (16, 'put cat #here', 'Thingy 1'); INSERT INTO ccc VALUES (17, 'put cat # here', 'IThingy2');
Guest Posted March 7, 2003 Posted March 7, 2003 OOps. Watch the typo in the file line. Should be ALTER TABLE products ADD Thingy1 varchar(30) NOT NULL default '', ADD Thingy2 varchar(30) NOT NULL default ''; INSERT INTO ccc VALUES (16, 'put cat #here', 'Thingy 1'); INSERT INTO ccc VALUES (17, 'put cat # here', 'IThingy2');
Guest Posted March 7, 2003 Posted March 7, 2003 Its not quite as simple as that. I have already added the extra fields and entries to the database. I have also duplicated code required to draw data from the tables. Now I have the extra fields showing but not inserting data into the database. The original categories show a product name. The ones I have added only show "Array" I have looked and pulled the code apart several times but cant seem to get this on to work for me
Recommended Posts
Archived
This topic is now archived and is closed to further replies.