4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Randomness
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
Daniel
Team Member



Joined: 06 Jan 2002
Posts: 2564

PostPosted: Sun Mar 09, 2003 8:24 am (14 years, 9 months ago) Reply with QuoteBack to Top

That's wierd. I've always seen it used as though it was random... In fact I've never noticed it not being random (but then I probably don't pay enough attention Very Happy). Anyone know? Question

________________________________
Image
OfflineView User's ProfileFind all posts by DanielSend Personal Message
Darren
Team Member



Joined: 05 Feb 2002
Posts: 549
Location: London

PostPosted: Sun Mar 09, 2003 11:52 am (14 years, 9 months ago) Reply with QuoteBack to Top

Interestingly its the first record in the table out of about 30 that is appearing more often than not

http://www.mysql.com/doc/en/Mathematical_functions.html#IDX1255 wrote:
You can't use a column with RAND() values in an ORDER BY clause, because ORDER BY would evaluate the column multiple times.


maybe this is why, I was selecting specific columns

it also says:
Quote:
RAND() is not meant to be a perfect random generator
OfflineView User's ProfileFind all posts by DarrenSend Personal MessageVisit Poster's Website
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   


Go to page Previous  1, 2

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.055686 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme