[PHP-DB] More random RAND() in MYSQL

[Graham Anderson]

The ORDER BY RAND() function is not incredibly random
Is there some way to make RAND() a bit more spontaneous ?


$sql = "SELECT media.id,
                artist.name as artist,
                artist.spanish as bio,
                artist.purchaseLink,
                artist.picture,
                media.spanish as trackName,
                media.path,
                media.quality,
                mediaType.id as mediaType
                FROM artist, media, playlistItems, mediaType
                WHERE playlistItems.playlist_id = $myID
                AND playlistItems.media_id = media.id
                AND media.artist_id = artist.id
                AND media.mediaType_id = mediaType.id
        ORDER BY RAND() LIMIT 0, 30";


many thanks
g

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php