1. 

   laogui Administrator

   Staff Member

   Joined:

   Aug 30, 2005

   Messages:

   15,216

   Likes Received:

   35

   MySQL中使用rand()以及limit可以轻松实现随机记录显示功能
   
   select * form table order by rand() limit 0,10
   
   
   说明：以上为随机显示table中的10条记录，修改limit后参数可以定制显示条件

    

   #1 laogui, Nov 16, 2005
2. 

   老林 New Member

   Joined:

   Sep 6, 2005

   Messages:

   10,580

   Likes Received:

   36

   286

    

   #2 老林, Nov 17, 2005
3. 

   Tinque New Member

   Joined:

   Nov 21, 2005

   Messages:

   3

   Likes Received:

   0

   老鬼这个名字就是286时代得产物^_^
   为了老鬼,我注册了...哇````````````

    

   #3 Tinque, Nov 21, 2005