Results 1 to 4 of 4

Thread: RAND() error

  1. Jan 26th, 2003, 12:21 AM #1
    stickman373
    stickman373 is offline

    Thread Starter
    Fanatic Member stickman373's Avatar
    Join Date
    Mar 2001
    Location
    MA
    Posts
    909

    RAND() error

    What's wrong with this statement?

    PHP Code:
    $query = mysql_query("SELECT link FROM downloads WHERE version='".$version."' ORDER BY RAND() LIMIT 1"); 
    I run this and always get the same entry for a link. There are 3 different rows which match the criteria, but I always get the same row everytime i run the script.....:Bang:
    Reply With Quote Reply With Quote
  2. Jan 26th, 2003, 11:34 AM #2
    phpman
    phpman is offline
    Frenzied Member
    Join Date
    Nov 1999
    Posts
    1,337
    what version of mysql are you using?

    also remeber that RAND() is not meant to be a perfect random generator.
    Reply With Quote Reply With Quote
  3. Jan 26th, 2003, 11:56 AM #3
    stickman373
    stickman373 is offline

    Thread Starter
    Fanatic Member stickman373's Avatar
    Join Date
    Mar 2001
    Location
    MA
    Posts
    909
    3.23.54-nt is my mysql version

    and i know it isnt perfect, but i ran it over 200 times and it is always the same output. thats not right
    Reply With Quote Reply With Quote
  4. Jan 26th, 2003, 12:10 PM #4
    phpman
    phpman is offline
    Frenzied Member
    Join Date
    Nov 1999
    Posts
    1,337
    well I can see version='$version' it will always be what the $version is, it can't be random. try it like this

    PHP Code:
    $query = mysql_query("SELECT link FROM downloads ORDER BY RAND() LIMIT 1"); 
    what is $version and where is it coming from?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width