Forums
This topic is locked
Page click statistics with ASP
Posted 20 May 2003 16:59:50
1
has voted
20 May 2003 16:59:50 Pirke de Koning posted:
<font face='Arial'>Someone got an idea how to sort links by clicks? I'm using a database, with links in them and I would like to now if the most-clicked link can appear on top, followed by the 2nd-most and so on...
thanks in advance
</font id='Arial'>
Edited by - Kriep on 20 May 2003 17:00:45
Replies
Replied 20 May 2003 23:00:13
20 May 2003 23:00:13 Jonathan Danylko replied:
I would suggest having a table as follows:
<pre id=code><font face=courier size=2 id=code>
Name Type Length
-----------------------------------
LinkID AutoNumber --
LinkName Text 50
LinkAddress Text 50
Clicks Number --
</font id=code></pre id=code>
When they click on the link, pass the LinkID into a separate script and add 1 to the clicks field. Then proceed to the Response.Redirect them to the LinkAddress.
Hope this helps...
L8R,
Vitoman, M CIW D, MMCP
----------------------------------
He conquers who endures. - Persius
<pre id=code><font face=courier size=2 id=code>
Name Type Length
-----------------------------------
LinkID AutoNumber --
LinkName Text 50
LinkAddress Text 50
Clicks Number --
</font id=code></pre id=code>
When they click on the link, pass the LinkID into a separate script and add 1 to the clicks field. Then proceed to the Response.Redirect them to the LinkAddress.
Hope this helps...
L8R,
Vitoman, M CIW D, MMCP
----------------------------------
He conquers who endures. - Persius