I’m not that great at PHP or MySQL so I had to sit down and really look at how to edit the categories. This help is for the beginners like myself. Here is my 15 seconds of fame.

You will need to edit the jobberbase.sql file found in _db folder. I used a free SQL editor but you can use Notepad or WordPad.

Once you have the jobberbase.sql open find the CREATE TABLE IF NOT EXISTS ‘categories’

Right under that you should see this--

INSERT INTO `categories` (`id`, `name`, `var_name`) VALUES
(1, 'Programmers', 'programmers'),
(2, 'Designers', 'designers'),
(3, 'Administrators', 'administrators'),
(7, 'Marketers', 'marketers'),
(5, 'Testers', 'testers'),
(6, 'Editors', 'editors'),
(8, 'Managers', 'managers'),
(9, 'Consultants', 'consultants');

You can arrange the categories anyway you want. The numbers mean the order they are displayed. I changed my file to read 1 – 9 and edited them with the categories I wanted.

After you edit the file save it as jobberbase.sql and import/ upload to your database. If you have already uploaded the original jobberbase.sql you may have to delete the tables and then import/ upload the one you just made.

That’s it, your all done.