On Apr 9, 2005 9:09 AM, FxParlant <f-x.p(a)laposte.net> wrote:
Hello,
I'm trying to build a table with the IDs of the categorylinks table:
Id of the cl_to | Id of the cl_from
It seems simple, by however I'm totally confused by its structure.
Please, help;
François
François,
I'm not certain I fully understand what you want to do. However, I'll
give some information that I hope will help. If you need more, please
let me know.
In the categoryLinks table:
cl_from is the id of the article where the [[category:foo]] entry appears.
cl_to is the _title_ of the category page (in this example, "foo". The
"category:" prefix is assumed).
Note that since there can be multiple category entries on any page,
the cl_from field is not unique.
Note that cl_to is stored as a title instead of as an id because it is
possible to add [[category:bar]] to a page when there is no category
page named "bar".
The combination of (cl_from, cl_to) should be unique. Multiple
instances of the same category entry in an article are only entered
into categoryLinks once.
I hope this helps!
--Rich Holton
[[W:en:User:Rholton]]