Gossamer Forum
(Advanced Search)
for
Nov 25, 2002, 3:59 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Nov 25, 2002, 3:59 AM
Views: 23957
Shortcut
Quote Reply
RAND()
With the following query;

SELECT * FROM advertiser_info WHERE CreditLeft >= 0.5 ORDER BY RAND() LIMIT 1

If the RAND() function was not enabled on that version of MySQL, would it yeild an error, or just ignor it? For some resone, when I run this command, it ALWAYS returns the same result. I know definatly there are 3 results in the table...but only one of them ever seems to get chosen Unsure

Any ideas?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread RAND() Andy 23957 Nov 25, 2002, 3:59 AM
Thread Re: [Andy] RAND() 		Stealth 23701 Nov 25, 2002, 10:56 AM
Thread Re: [Stealth] RAND() 		Andy 23701 Nov 26, 2002, 2:03 AM
Thread Re: [Andy] RAND() 		cornball 23600 Nov 26, 2002, 10:55 AM
Thread Re: [cornball] RAND() 		Andy 23584 Nov 27, 2002, 1:26 AM
Thread Re: [Andy] RAND() 		Alex 23616 Nov 27, 2002, 11:47 AM
Thread Re: [Alex] RAND() 		Andy 23591 Nov 28, 2002, 2:05 AM
Thread Re: [Andy] RAND() 		SpeedStreet 23095 Jan 23, 2003, 7:20 AM
Post Re: [SpeedStreet] RAND() 		neb_greely 22863 Feb 4, 2003, 9:15 PM
Post Re: [SpeedStreet] RAND() 		faction 21661 Jul 30, 2003, 6:50 AM
Thread Re: [cornball] RAND() 		Alex 23566 Nov 27, 2002, 11:49 AM
Thread Re: [Alex] RAND() 		cornball 23587 Nov 27, 2002, 12:33 PM
Thread Re: [cornball] RAND() 		Alex 23515 Nov 27, 2002, 12:46 PM
Thread Re: [Alex] RAND() 		cornball 23567 Nov 27, 2002, 1:19 PM
Post Re: [cornball] RAND() 		Wil 23460 Nov 27, 2002, 1:47 PM
Post Re: [Andy] RAND() 		Annelid 22310 Apr 19, 2003, 11:38 PM