SirChick Posted December 2, 2007 Share Posted December 2, 2007 Is there a way to get "all" rows in a query and then using a random to pick a row like for example row 8 of the current rows available.. and if that row is non existing die.? Quote Link to comment Share on other sites More sharing options...
Wes1890 Posted December 2, 2007 Share Posted December 2, 2007 you mean select a random DB row? use: mysql_query("SELECT * FROM your_table ORDER BY RAND() LIMIT 1"); that will select 1 random row Quote Link to comment Share on other sites More sharing options...
SirChick Posted December 2, 2007 Author Share Posted December 2, 2007 right ok thankyou i will play around with that and see what results i get out of it Quote Link to comment 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.