Posted by TintedS on 01/15/06 03:55

Hi.

my db has

categories(CatID,ParentID,CatName)
items(ItemID,CatID,ItemName)

I need to retrieve particular items (Ex: ItemID=1,5,19,36). The problem
is I cannot make it that way that the item is under necessary
categories and subcategories.

Ex:
ParentID=0
ParentID=4
ParentID=10
...
ItemID=1

Thanx in advance

• Next in forum: ALTER column
• Prev in forum: Re: why i can`t use rand() i functions within ?
• Thread view: Categories, subcategories retrieving problem

[Reply to this message]