I was thinking about the whole Categories issue on the Chyrp Lite blog, and it  was really irritating me. The only way to really test this theory was to  actually enter the values in the database and see what I got. I was  going to do this by hand, but then I got to thinking and realised that  perhaps scripting it would be a better way to do things. After all, I  need the practise, right?

/* First MySQL script to input initial values into chyrp
*
*/
SHOW DATABASES;
USE chyrp;
SHOW TABLES;
SELECT * from categorize;
INSERT into categorize (name, clean) VALUES ('draigie', 'Draigie');
INSERT into categorize (name, clean) VALUES ('casgliad', 'Casgliad');
INSERT into categorize (name, clean) VALUES ('casglu', 'Casglu');
INSERT into categorize (name, clean) VALUES ('cyfrifo', 'Cyfrifo');
INSERT into categorize (name, clean) VALUES ('rhybudd', 'Rhybudd');
INSERT into categorize (name, clean) VALUES ('diweddaru', 'Diweddaru');
INSERT into categorize (name, clean) VALUES ('adrodd', 'Adrodd');
SELECT * from categorize;

It did a lot of the things that I was expecting it to do, however I  am not happy with the way it presents on the actual page and perhaps I  don't properly understand how it is designed. I had my capitalisation  backwards, and I would rather nest some of these.  I wonder what happens  when I increase the numbers, or if the 1 has a 0 to turn it off. If it is a binary switch sort of thing, that's one  thing. If it is different and the number provides levelling, that's a  whole other beast. Hoping it's the latter.