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
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!
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
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!