RE: [PHP-DB] Unlimited Categories

Well, I'm not sure if you actually truly mean "unlimited", because if you do, be aware that when you define those fields: # BIGINT UNSIGNED = 8 Byte = FFFFFFFFFFFFFFFF = 18446744073709551615 # INT UNSIGNED = 4 Byte = FFFFFFFF = 4294967295 # MEDIUMINT UNSIGNED = 3 Byte = FFFFFF = 16777215 # SMALLINT UNSIGNED = 2 Byte = FFFF = 65535 # TINYINT UNSIGNED = 1 Byte = FF = 255 # BIGINT SIGNED = -9223372036854775808 to 9223372036854775807 # INT SIGNED = -2147483648 to 2147483647 # MEDIUMINT SIGNED = -8388608 to 8388607 # SMALLINT SIGNED = -32768 to 32767 # TINYINT SIGNED = -128 to 127 So, while an UNSIGNED BIGINT would be a bahugabyte number, it is in fact finite and not unlimited. :) > -----Original Message----- > From: Micah Stevens [mailto:micah@raincross-tech.com] > Sent: Monday, January 13, 2003 9:45 PM > To: Gerard Samuel > Cc: php-db > Subject: Re: [PHP-DB] Unlimited Categories > > > Use the parent/child relationship thing: > > CREATE TABLE Categories ( > CategoryID int(11) NOT NULL auto_increment, > ParentID int(11) NOT NULL default '0', > Category_Name tinytext NOT NULL, > PRIMARY KEY (CategoryID) > ) TYPE=MyISAM; > > So at each level you can find the subcategories by: > > SELECT * FROM Category WHERE ParentID = $This_Level_ID; > > The top level would have a ParentID of 0. > > *shrug* - One way to do it. > > -Micah > > On Mon, 2003-01-13 at 21:32, Gerard Samuel wrote: > > > Im figuring this is more of an sql question than anything else. > > I'm trying to figure out a table structure to create > unlimited depths of > > categorical data. > > I've done something for category/subcategories before, but > haven't an > > idea how to create categories at an unlimited depth. > > > > Any pointers would be greatly appreciated. > > Thanks > > > > -- > > Gerard Samuel > > http://www.trini0.org:81/ > > http://dev.trini0.org:81/ > > -- > Raincross Technologies > Development and Consulting Services > http://www.raincross-tech.com > >