yarub Posted March 5, 2006 Share Posted March 5, 2006 Let's say I have 100 entries in a database, and I'd like to just put one random entry on my homepage. How would I go about doing that? It doesn' t have to be for a set period of time or anything. I just want to have a random entry with every refresh of the page. Is that easy to do? >_> Quote Link to comment https://forums.phpfreaks.com/topic/4170-pull-a-random-row/ Share on other sites More sharing options...
earl_dc10 Posted March 6, 2006 Share Posted March 6, 2006 yes, very easy, just do this:[code]$select = "SELECT * FROM $table";$select_query = mysql_query($select, $link) or die("Couldn't select <value".mysql_error() );$num = mysql_num_rows($select_query) // get the number of rows$id = $num-1; // since mysql_num_rows starts at 1and id's start at 0$rand = rand(0, $id); //random statement$get = "SELECT <value> FROM $table WHERE id='$rand'";$get_query = mysql_query($get, $link) or die("Couldn't select <value>".mysql_error() );[/code] Quote Link to comment https://forums.phpfreaks.com/topic/4170-pull-a-random-row/#findComment-14493 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.