Changing number of users on MYSQL Database

Discussion in 'MySQL' started by andyleem, Jun 13, 2007.

0
  1. #1
    Hi,
    I have a referral script and i want to set the user id's to start at a specific number, such as 500.
    When someone signs up to my site 360claim.com they are assigned a referral ID, which is shown in the MYSQL database.
    I want it so that when they sign up they will be given a higher referral number. Therefore making it look more professional as it will appear that there are more users.
    is this possible, any help would be appreciated.
    andy
     
    andyleem, Jun 13, 2007 IP
  2. LegendaryPosting

    LegendaryPosting Peon

    Messages:
    711
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #2
    have a random number created or maybe a counter script..?
     
    LegendaryPosting, Jun 13, 2007 IP
  3. andyleem

    andyleem Active Member

    Messages:
    490
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    83
    #3
    Yeah i guess that if someway a user is registered with a random ID it would solve it.
    Thinking about it, is there a way of the ID being generated randomly between an amount?
    Such as one user registers and gets ID 505 and then next gets 950 (between 1 and 1000)..
     
    andyleem, Jun 13, 2007 IP
  4. Clark Kent

    Clark Kent Guest

    Messages:
    122
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Manually insert a user with high userID . Next inserted records will continue from that number. You can always update or manipulate autoincrement fields on mysql. (In mssql you have to set identity insert on)
     
    Clark Kent, Jun 14, 2007 IP