List:General Discussion« Previous MessageNext Message »
From:Richard Whitney Date:April 11 2005 2:41pm
Subject:Re: results in random order.
View as plain text  
Quoting Richard Reina <richard@stripped>:

> I am trying to get this query to randomly pick a
> record from a table (trans) but it's not working:
>
> SELECT ID FROM trans ORDER BY RAND() LIMIT 1;
>
> Can anyone let me know what I'm doing wrong and/or how
> to fix it.
>
> Thanks,
>
> Richard
>

What error(s) is it giving you?
Does it always return the same record?
Is there more than one record in trans?

I change the name of the table and tested it against mine and it works fine

R. Whitney
Transcend Development
"Producing the next phase of your internet presence"
http://xend.net
Premium Quality Web Hosting
http://xendhosting.com
rw AT xend.net
Net Binder  http://netbinder.net
310-943-6498
602-288-5340

Thread
results in random order.Richard Reina11 Apr
  • Re: results in random order.Richard Whitney11 Apr