Hi,

I am looking for a tutorial on how to put a small table on the side of my site showing the 5 or 10 or whatever most searched item. Just like the one that is on UdZone. Is there a tutorial somewhere on this site because I have looked everywhere and can't find it yet.

I would really appreciate it if someone could point me in the right direction or let me know how to do it.

By the way, I am using access 2000, iis 5, windows 2000 professional.

Thanks,

Adam Toohey

Off the top of my head I would do the following:

-submit the search term (item) to a db table
-then use SQL's GROUP BY clause and the COUNT function to get the number of times each distinctive search term has been used
-then simply write your top 5 or 10 to the page


Let me know what you think.

Hi Jaggs,

That looks easy enough, only I don't know how to do it <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Could you please show me how to do it? I know how to finish it by adding the table but don't know the in betweens.

This is what I don't know how to do:

-submit the search term (item) to a db table
-then use SQL's GROUP BY clause and the COUNT function to get the number of times each distinctive search term has been used


Thanks in advance,

Adam Toohey

Edited by - adam2e on 19 Jan 2002 08:11:49

Adam, how much raw ASP (forget UltraDev for a minute) do you know?

Very little <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> I know how it all works and can mostly read it, but don't write it raw unless I see a tutorial......

Looking forward to your response,

Adam

I will put something together for you as quickly as my schedule allows, but in the meantime I would like to invite you to www.haneng.com in order to get you started with "real" ASP <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>~
You will find me in the forum under jags. Please don't get me wrong, I'm not trying to trash this forum, it's just that I have learned so much from the guys that hang out in haneng's forum and I would like you to experience the same. Hope to see you there...

Tom