Forums
This topic is locked
How do I create such Directory Listings with UD?
02 May 2002 22:32:37 Arnold Ho posted:
Take a look. www.download.comWould anyone like to discuss the easiest way to achieve this effect?
Thanks!
Replies
Replied 03 May 2002 01:09:38
03 May 2002 01:09:38 Andrew Watson replied:
If you mean the directory that shows categories with related sub categories then this is quite simple with a well thought out database and UD.
Say, for example you had listings which were part of a sub category which in turn were part of a category.
In the case of CNet Downloads youve got a download, WS_FTP.exe which is part of the category FTP, which in turn belong to the category WEB DEVELOPER. so all you need (basically!!) is three tables,
tblDownloads
containing:
DownloadID (Autonumber) (Key)
DowmloadName (Text)
DownloadFile (Text)
SubCategoryID (Number)
tblSubcategories
containing:
SubCategoryID (Autonumber) (Key)
SubCategoryName (Text)
CategoryID (Number)
tblCategories
containing:
CategoryID (Autonumber) (Key)
CategoryName (Text)
These are related simply by...
Any 1 Category in tblCategories can have unlimited SubCategories which in turn can have unlimited Downloads.
Then to display them on your page you simply have to use a nested repeat region.
There is a good tutorial here on UDZone on this so i wont blether on...
So you basically have a repeat region which shows all your Categories, for each record in this repeat there is another repeat showing all the related Subcategories.
Check out the tutorial, if you cant get it ill post a wee dod o code.
This will achieve this effect very simply, all the rest (top tens, etc is just gravy <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
:: Son, im Thirty.... ::
Say, for example you had listings which were part of a sub category which in turn were part of a category.
In the case of CNet Downloads youve got a download, WS_FTP.exe which is part of the category FTP, which in turn belong to the category WEB DEVELOPER. so all you need (basically!!) is three tables,
tblDownloads
containing:
DownloadID (Autonumber) (Key)
DowmloadName (Text)
DownloadFile (Text)
SubCategoryID (Number)
tblSubcategories
containing:
SubCategoryID (Autonumber) (Key)
SubCategoryName (Text)
CategoryID (Number)
tblCategories
containing:
CategoryID (Autonumber) (Key)
CategoryName (Text)
These are related simply by...
Any 1 Category in tblCategories can have unlimited SubCategories which in turn can have unlimited Downloads.
Then to display them on your page you simply have to use a nested repeat region.
There is a good tutorial here on UDZone on this so i wont blether on...
So you basically have a repeat region which shows all your Categories, for each record in this repeat there is another repeat showing all the related Subcategories.
Check out the tutorial, if you cant get it ill post a wee dod o code.
This will achieve this effect very simply, all the rest (top tens, etc is just gravy <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
:: Son, im Thirty.... ::
Replied 07 May 2002 11:22:02
07 May 2002 11:22:02 Arnold Ho replied:
I can't find the Tutorial. Would you please direct me to it?
Thank you so much!
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
If you mean the directory that shows categories with related sub categories then this is quite simple with a well thought out database and UD.
Say, for example you had listings which were part of a sub category which in turn were part of a category.
In the case of CNet Downloads youve got a download, WS_FTP.exe which is part of the category FTP, which in turn belong to the category WEB DEVELOPER. so all you need (basically!!) is three tables,
tblDownloads
containing:
DownloadID (Autonumber) (Key)
DowmloadName (Text)
DownloadFile (Text)
SubCategoryID (Number)
tblSubcategories
containing:
SubCategoryID (Autonumber) (Key)
SubCategoryName (Text)
CategoryID (Number)
tblCategories
containing:
CategoryID (Autonumber) (Key)
CategoryName (Text)
These are related simply by...
Any 1 Category in tblCategories can have unlimited SubCategories which in turn can have unlimited Downloads.
Then to display them on your page you simply have to use a nested repeat region.
There is a good tutorial here on UDZone on this so i wont blether on...
So you basically have a repeat region which shows all your Categories, for each record in this repeat there is another repeat showing all the related Subcategories.
Check out the tutorial, if you cant get it ill post a wee dod o code.
This will achieve this effect very simply, all the rest (top tens, etc is just gravy <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
:: Son, im Thirty.... ::
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Thank you so much!
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
If you mean the directory that shows categories with related sub categories then this is quite simple with a well thought out database and UD.
Say, for example you had listings which were part of a sub category which in turn were part of a category.
In the case of CNet Downloads youve got a download, WS_FTP.exe which is part of the category FTP, which in turn belong to the category WEB DEVELOPER. so all you need (basically!!) is three tables,
tblDownloads
containing:
DownloadID (Autonumber) (Key)
DowmloadName (Text)
DownloadFile (Text)
SubCategoryID (Number)
tblSubcategories
containing:
SubCategoryID (Autonumber) (Key)
SubCategoryName (Text)
CategoryID (Number)
tblCategories
containing:
CategoryID (Autonumber) (Key)
CategoryName (Text)
These are related simply by...
Any 1 Category in tblCategories can have unlimited SubCategories which in turn can have unlimited Downloads.
Then to display them on your page you simply have to use a nested repeat region.
There is a good tutorial here on UDZone on this so i wont blether on...
So you basically have a repeat region which shows all your Categories, for each record in this repeat there is another repeat showing all the related Subcategories.
Check out the tutorial, if you cant get it ill post a wee dod o code.
This will achieve this effect very simply, all the rest (top tens, etc is just gravy <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
:: Son, im Thirty.... ::
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 08 May 2002 02:17:34
08 May 2002 02:17:34 Andrew Watson replied:
Somwhere over there....
www.udzone.com/showDetail.asp?TypeId=2&NewsId=394
Cheers
Leed
:: Son, im Thirty.... ::
www.udzone.com/showDetail.asp?TypeId=2&NewsId=394
Cheers
Leed
:: Son, im Thirty.... ::
Replied 08 May 2002 03:05:27
08 May 2002 03:05:27 Arnold Ho replied:
Thanks! Its has also revealed more options to me. I am gonna take a look at all of them before deciding...
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Somwhere over there....
www.udzone.com/showDetail.asp?TypeId=2&NewsId=394
Cheers
Leed
:: Son, im Thirty.... ::
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Somwhere over there....
www.udzone.com/showDetail.asp?TypeId=2&NewsId=394
Cheers
Leed
:: Son, im Thirty.... ::
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>