RE: Unlimited Categories

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:  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
> 
> 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux