CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Beginner:
order by rand() (MySQL query)

 



pu_nk
journeyman

Mar 9, 2001, 12:41 AM

Post #1 of 2 (101 views)
order by rand() (MySQL query) Can't Post

I am new at working with MySQL queries but can most of the time get what i want out of the table etc...

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 ?

Drew



pu_nk
journeyman

Mar 10, 2001, 7:49 AM

Post #2 of 2 (96 views)
Re: order by rand() (MySQL query) [In reply to] Can't Post

well i figured out the problem.. it was the version of MySQL.. version 3.22 does not support rand() while 3.23 does support it.

drew


 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives