NextGenForum.net Posted October 26, 2007 Share Posted October 26, 2007 Hi, I run a site - www.selectgreen.co.uk and as you can see there is a section called featured company. I want to pull out a random entry from about 11 databses altogether in order for it to show up as a featured company everyday. I dont know if this is possible, but help appreciated (hope im clear here ) Thanks Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/ Share on other sites More sharing options...
fenway Posted October 26, 2007 Share Posted October 26, 2007 Not really... define "random". Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-378615 Share on other sites More sharing options...
NextGenForum.net Posted October 26, 2007 Author Share Posted October 26, 2007 I mean that every day, i want a different company to appear. I have 11 databases one for each category (property, music etc...) So i need to somehow pull out an entry from one of these databases to appear in the featured company box. i probably havent made my self any clearer, but thats the best i can explain it. sorry Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-378632 Share on other sites More sharing options...
fenway Posted October 26, 2007 Share Posted October 26, 2007 You could union them and pick a random one... that would be quite slow. Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-378645 Share on other sites More sharing options...
NextGenForum.net Posted October 26, 2007 Author Share Posted October 26, 2007 i wudnt know where to start, could you tell me, THanks also how long?? Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-378651 Share on other sites More sharing options...
fenway Posted October 26, 2007 Share Posted October 26, 2007 Is your UID key distribution "even" (i.e. not too many deleted rows?)? Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-378781 Share on other sites More sharing options...
NextGenForum.net Posted October 26, 2007 Author Share Posted October 26, 2007 well i only have 2 entries, 1 and 2 being there ids, if by UIDs you mean unique id's - primary keys? Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-378791 Share on other sites More sharing options...
fenway Posted October 26, 2007 Share Posted October 26, 2007 Yes, that's right... I want to know of I get the MIN/MAX of the ID field, and pick a random one, will be really be "random". Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-378795 Share on other sites More sharing options...
NextGenForum.net Posted October 26, 2007 Author Share Posted October 26, 2007 will be really be "random".????? sorry dont get you there, sorry :-\ Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-378796 Share on other sites More sharing options...
NextGenForum.net Posted October 27, 2007 Author Share Posted October 27, 2007 i could do with some help! Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-379281 Share on other sites More sharing options...
NextGenForum.net Posted October 28, 2007 Author Share Posted October 28, 2007 please help fenway, Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-379733 Share on other sites More sharing options...
fenway Posted October 29, 2007 Share Posted October 29, 2007 will be really be "random".????? sorry dont get you there, sorry :-\ Yes... is the PK auto-increment? Do you delete records? Is the key distribution even? Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-380373 Share on other sites More sharing options...
NextGenForum.net Posted October 29, 2007 Author Share Posted October 29, 2007 yea the pk is aut-incremetn, and the key distribution is even yes, Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-380589 Share on other sites More sharing options...
fenway Posted October 29, 2007 Share Posted October 29, 2007 If so, then get back min/max of the uid field for the table, and pick one "in the middle": $range_result = mysql_query( " SELECT MAX(`id`) AS max_id , MIN(`id`) AS min_id FROM `table` "); $range_row = mysql_fetch_object( $range_result ); $random = mt_rand( $range_row->min_id , $range_row->max_id ); $result = mysql_query( " SELECT * FROM `table` WHERE `id` >= $random LIMIT 0,1 "); Link to comment https://forums.phpfreaks.com/topic/74886-random-selection-from-a-database/#findComment-380624 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.