Tripmon has very graciously supplied with mx-Directory a file named MXDIR_cats.sql containing sample categories to be inserted into the database. Here are some sample lines of code from the file showing a few top-level categories and a few sub-categories:



I would like to change this file to contain my category list, and I am wondering what the rules are concerning the numbering sequence.

For example, Tripmon begins with number 154 for the first main category. Is there a reason for this particular number?

Also, could I number the main categories like 160, 170, 180, etc., so as to leave room to insert other categories later if necessary should I think of something to add before the file is finalized? Or must they be consecutive right from the start?

Also, could the numbering system contain, say, 4 digits instead of 3?

And, if there are third level categories, what would the syntax be?

Any suggestions as to how best to layout this file will be very much appreciated.

JFM

Hi JFM,

You can use any numbers you wish and there will be no ill effects.

The only thing you need to be concerned about is the Sub-Cats being correctly linked to the Parent Cat.

There was no real reason for the numbering, I just ran a drop of my current Dir structure from MyAdmin and that happened to be the Category ID's.

You should also not need to leave spaces for later inserts.

PM me if you have any other questions or problems.

If the first column is an auto incremented field, it does not matter which number you put in there. MySQL will ignore the number of the category and automatically use the first available number for that record.