EZE Posted February 24, 2007 Share Posted February 24, 2007 I'm still pretty new to MySql, so I didn't know how to do this. I have a MySql table set up with phpmyadmin like this: What i am trying to do is randomize info from a this table. Like so: (HTML Output:) <a href="watch.php?id=RANDOM TABLE ID">RANDOM MOVIE NAME FOR THE SAME ID AS LINK</a> Something like that. Only 1 random string though. I don't really know how to explain what I am trying to do, but i hope someone can help. Quote Link to comment https://forums.phpfreaks.com/topic/39887-mysql-row-randomization/ Share on other sites More sharing options...
btherl Posted February 26, 2007 Share Posted February 26, 2007 Check this thread: http://www.phpfreaks.com/forums/index.php/topic,125759.0.html The simplest method is just "ORDER BY RAND() LIMIT 1", but that isn't efficient for large data sets. Try it out and see if it's fast enough for you. If it is, no need to do any more Quote Link to comment https://forums.phpfreaks.com/topic/39887-mysql-row-randomization/#findComment-194098 Share on other sites More sharing options...
worldworld Posted February 26, 2007 Share Posted February 26, 2007 I think you have to use WHERE ur=' ' tag along with ORDER BY RAND() LIMIT 1. Try it... Quote Link to comment https://forums.phpfreaks.com/topic/39887-mysql-row-randomization/#findComment-194206 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.