Mar 9, 2001, 12:41 AM
Post #1 of 2
I am new at working with MySQL queries but can most of the time get what i want out of the table etc...
order by rand() (MySQL query)
But..... i have run into a stumper.....
I can run a query with the following on my site , but not off a friends server when i tried to install the software there.. It can not execute() $sth ...
SELECT * FROM table_name WHERE status = 'active' ORDER BY rand() LIMIT
any ideas why this works on 1 server but not the other ?