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. 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 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... Link to comment https://forums.phpfreaks.com/topic/39887-mysql-row-randomization/#findComment-194206 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.