Help-choosing data randomly

Discussion in 'PHP' started by ItamarP, Jul 3, 2009.

0
  1. #1
    let's imagine there are 10 different questions in the database and i only want to pull one of them randomly

    how can i do it?


    thanks in advance
     
    ItamarP, Jul 3, 2009 IP
  2. syariscrewz

    syariscrewz Banned

    Messages:
    37
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    just use 'rand' command .
     
    syariscrewz, Jul 3, 2009 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    SELECT * FROM my_table ORDER BY RAND() LIMIT 1
     
    jestep, Jul 3, 2009 IP
  4. Bohra

    Bohra Prominent Member

    Messages:
    12,573
    Likes Received:
    537
    Best Answers:
    0
    Trophy Points:
    310
    #4
    RAND() should do the trick
     
    Bohra, Jul 3, 2009 IP