Textpattern CMS

#1 2007-11-28 22:55:46

Logoleptic

Plugin Author

From: Kansas, USA

Registered: 2004-02-29

Posts: 482

lft and rgt fields in txp_category table

Quick question: what are these, and what are they for? Couldn’t find anything in Textbook.

Last edited by Logoleptic (2007-11-28 22:56:11)

#2 2007-11-28 23:19:56

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: lft and rgt fields in txp_category table

Between l(e)ft and r(i)g(h)t, the child categories reside.

#3 2007-11-28 23:58:01

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: lft and rgt fields in txp_category table

http://www.sitepoint.com/article/hierarchical-data-database

#4 2007-11-29 19:52:05

Logoleptic

Plugin Author

From: Kansas, USA

Registered: 2004-02-29

Posts: 482

Re: lft and rgt fields in txp_category table

Thanks for your help, and especially for the link.