View Single Post
  #7  
Old 04-27-2009, 05:53 AM
mojaruu mojaruu is offline
Member
 
Join Date: Mar 2009
Posts: 2
Credits: 237
mojaruu
Default RE: Random 5 is not realy random!

Quote:
Originally Posted by RipJawWolfFang
Alright... So can you tell me how to eather fix it or remove it all together without brakeing anything?
i fixed it by using this code:

PHP Code:
$query "SELECT * FROM ".$prefix."owned_adoptables ORDER BY RAND() LIMIT 5 OFFSET ".$offset.""
instead of this one

PHP Code:
$query "SELECT * FROM ".$prefix."owned_adoptables ORDER BY totalclicks DESC LIMIT 20 OFFSET ".$offset.""
on stats.php. and *poof* its seems that its now randomly listed.

:D
Reply With Quote