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.
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
"Producing the next phase of your internet presence"
Premium Quality Web Hosting
rw AT xend.net
Net Binder http://netbinder.net