| Author |
 Topic Search  Topic Options
|
farrukh 
Groupie
Joined: 10 May 2002
Location: Pakistan
Status: Offline
Points: 147
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Problem Help Me..
Posted: 16 April 2003 at 3:52am |
i m going to built the directory of webmaster like ASPIN.com but i have a problem i made three tables called tblCategory, tblComponents, tblSub_Categories.
which helps me like these
ASP > Source and Scripts >> Discussion Forums
Category >> Component >> SubCategory
my database support these kind of structure but i stuck to these
What Should i do in this type?
ASP > Source and Scripts >> Counters >> Graphical >>
Do i introduce one more table for it. or what should i do
i could have more subCategories what should i do.
Help required ne database Designer here
|
|
i have collected some nice avatars (37) and smileys (227) here you can download
http://www24.brinkster.com/webmastertool/download.html
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 April 2003 at 8:00am |
|
As you probably don't know how many subcategories you are going to have I would not do it that way at all. Put it all in one table like follows:
Cat_ID int
Cat_Nm varchar(xx)
SubCatOf_ID int
That way, if it is a main category it has NULL as SubCatOf_ID so you display it, the you loop through the values that have SubCatOf_ID = Cat_ID and so forth. This way you save space and can have unlimited subcategories. Now depending on the database you are going to use I would encourage you to do the query in a SP which would speed up this process quite a bit. Of course there are other ways to do it but creating a table for each category is IMHO a bad idea, because you limit yourself.
|
|
|
|
farrukh
Groupie
Joined: 10 May 2002
Location: Pakistan
Status: Offline
Points: 147
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 April 2003 at 12:22pm |
k micheal i will do this thanx hey i have added 1104 scripts so far in ten days and still i m adding. what should you recommend me please check http://www24.brinkster.com/webmastertool/db/pllease give some feedbacks http://www24.brinkster.com/webmastertool/db/index.asp my new look
Edited by farrukh
|
|
i have collected some nice avatars (37) and smileys (227) here you can download
http://www24.brinkster.com/webmastertool/download.html
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 April 2003 at 12:44pm |
|
First I would get rid of the welcome text up top, that looks cheezy (but that's just me) The layout I think is good though i am not a friend of brown, again is a matter of taste. Be careful with adding scripts that are not yours, some developers don't want there stuff listed without their conscent
|
|
|
|
farrukh
Groupie
Joined: 10 May 2002
Location: Pakistan
Status: Offline
Points: 147
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 April 2003 at 11:53pm |
i will send a username and password to the script holder. so if they dont want to show there scripts they can delete it. when ever i add the script an email is sended to the script holders so if they dont agree then they could delete it. The welcome text is nothing the site is in underconstruction so i will delete it later on. Still i change my current look. I dont the work in my Database now i can have unlimited SubCategories. thnx for that micheal.
Do you know ne ad-management script which i put in my site.
|
|
i have collected some nice avatars (37) and smileys (227) here you can download
http://www24.brinkster.com/webmastertool/download.html
|
|
faubo
Senior Member
Joined: 30 May 2002
Location: Brazil
Status: Offline
Points: 560
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 April 2003 at 9:35am |
I actually like the brown, but sure you should be carefull with the script thing!
If you find a javascript that highlight a word in a text, let me know!!
|
|
|
|
farrukh
Groupie
Joined: 10 May 2002
Location: Pakistan
Status: Offline
Points: 147
|
Post Options
Thanks(0)
Quote Reply
Posted: 18 April 2003 at 12:22am |
check out these http://forums.webwiz.net/forum_posts.asp?TID=1849&KW=farrukh and see my name is highlighted if you are looking to this then add this cod to your .css .highlighter {BACKGROUND: #CCCCCC;} use it like <span class="highlighter">any thing </span> if you are not looking for this kind of highlighter then i m sorry
|
|
i have collected some nice avatars (37) and smileys (227) here you can download
http://www24.brinkster.com/webmastertool/download.html
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 18 April 2003 at 3:19pm |
|
If you want to highlight results from a search I use a function which works quite well:
function doHighlight(my_sentence, word_to_highlight)
my_output = "<span style='background:yellow'>" & word_to_highlight & "</span>"
doHighlight = replace(lcase(my_sentence), word_to_highlight, my_output)
End function
|
|
|
|
