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 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. 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. 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
Archived
This topic is now archived and is closed to further replies.