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 =
# 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:[EMAIL PROTECTED]]
> 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.
> 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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php