P
Paul
Hi,
I have a database (MSAccess 97) that contains all the links on my website,
and I want to create an "I feel lucky" page similar to what Google does.
The links that are to be included are in a table as follows
LINK_ID | LINK_PATH | CURRENT_Y/N | NEXT_LINK
1 | http://www....| Y | 2
(I hope that makes sense in your newsreader)
The idea is that my visitors will open a page (feeling_lucky.asp) and it
will take them to which ever record is current, and then change the current
record so in the example above it would re-direct to the path but firstly
change LINK_ID 1's CURRENT_Y/N field to a "N", and then update LINK_ID 2's
CURRENT_Y/N field to a "Y" ready for the next visitor.
I have tried to do this but I'm not sure if I'm going about it the wrong
way, so I thought I'd ask for your advice.
My questions are:
Is there a better way of doing this ? ( I don't want the visits to be
random, each link must get equal traffic)
Can it all be done in 1 ASP page, or will it need several ( 1 to get the
LINK_PATH and NEXT_LINK and pass them as a URL parameter, then 1 to update
the current record, then 1 to update the next record )?
I'd be grateful of any advice, or examples you can offer.
The project has 2 purposes, "I feel lucky" and then to monitor which
products are the best to display in our Offers area, so each visitor gets a
different page of offers, then I can see which products are genuinely good
sellers,and which are pants items nobody wants to buy.
Thanks for your help
Paul
I have a database (MSAccess 97) that contains all the links on my website,
and I want to create an "I feel lucky" page similar to what Google does.
The links that are to be included are in a table as follows
LINK_ID | LINK_PATH | CURRENT_Y/N | NEXT_LINK
1 | http://www....| Y | 2
(I hope that makes sense in your newsreader)
The idea is that my visitors will open a page (feeling_lucky.asp) and it
will take them to which ever record is current, and then change the current
record so in the example above it would re-direct to the path but firstly
change LINK_ID 1's CURRENT_Y/N field to a "N", and then update LINK_ID 2's
CURRENT_Y/N field to a "Y" ready for the next visitor.
I have tried to do this but I'm not sure if I'm going about it the wrong
way, so I thought I'd ask for your advice.
My questions are:
Is there a better way of doing this ? ( I don't want the visits to be
random, each link must get equal traffic)
Can it all be done in 1 ASP page, or will it need several ( 1 to get the
LINK_PATH and NEXT_LINK and pass them as a URL parameter, then 1 to update
the current record, then 1 to update the next record )?
I'd be grateful of any advice, or examples you can offer.
The project has 2 purposes, "I feel lucky" and then to monitor which
products are the best to display in our Offers area, so each visitor gets a
different page of offers, then I can see which products are genuinely good
sellers,and which are pants items nobody wants to buy.
Thanks for your help
Paul