Script to Random Pull a link each reload from a Database of 100 links

Discussion in 'HTML & Website Design' started by nismo, Mar 8, 2008.

0
  1. #1
    Hi

    Does anyone know how I can do this?

    Thank you
     
    nismo, Mar 8, 2008 IP
  2. nismo

    nismo Peon

    Messages:
    359
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Is it also possible to allow a maximum number of page loads for each link so that it will not exceed it?

    For example:

    I have

    Link 1
    Link 2
    Link 3
    Link 4

    Each time it will load a random link and what happens is that for Link 1, it will only load up to 100 times and then it will never load LInk 1 again for the day.
     
    nismo, Mar 8, 2008 IP
  3. nismo

    nismo Peon

    Messages:
    359
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Can anyone help on this?

    Thank you
     
    nismo, Mar 8, 2008 IP
  4. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #4
    To do both is straight forward enough but would be most efficient to do with a stored procedure in the db server and so it comes down to if your using SQL Server, MySQL etc
     
    AstarothSolutions, Mar 9, 2008 IP