hmm, this doesn't work on ym server but works localy?!
SELECT DIR FROM indexmedia ORDER BY RAND() LIMIT 1
is the RAND() function a new thing in MySQL? and if so is there any other way to go about retriving a single random row from a database?
Ordering by rand() was implented in MySQL 3.23.
how do i find out what version of MySQL the server is running and is there another way to do the same thing in earlier versions?
http://www.mysql.net/version
it's at the bottom of the page.
