PHPnewby! Posted February 16, 2007 Share Posted February 16, 2007 Hi guys, I'm trying to create a "member spotlight". I have the following fields which I would like to select and display at random from my "Members" table: Emailaddress (to become a link to email this member) DOB Interests Gender Moto TravelAspirations DestinationsVisited Message Any help would be greatly apreciated!! Thank you Quote Link to comment https://forums.phpfreaks.com/topic/38764-displaying-random-record-from-a-database/ Share on other sites More sharing options...
JasonLewis Posted February 16, 2007 Share Posted February 16, 2007 for starters look at the rand() function. there are a few ways of doing it with the rand() function, i am not to hot on creating funky sql queries, so someone else may be able to do something with sql queries for you. EDIT: see, ToonMariner made a fancy (not really) query. lol. Quote Link to comment https://forums.phpfreaks.com/topic/38764-displaying-random-record-from-a-database/#findComment-186260 Share on other sites More sharing options...
ToonMariner Posted February 16, 2007 Share Posted February 16, 2007 just put 'ORDER BY RAND()' at the wnd of your query. Quote Link to comment https://forums.phpfreaks.com/topic/38764-displaying-random-record-from-a-database/#findComment-186262 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.