 |
 |
 |
 |
|
|
Date: 05/01/01
- Next message: Alexander Bokovoy: "[PHP-DEV] Re: [PHP-CVS] cvs: php4 /ext/session php_session.h session.c /ext/wddx php_wddx_api.h wddx.c"
- Previous message: derick <email protected>: "[PHP-DEV] Re: [PHP-CVS] cvs: php4 /ext/session php_session.h session.c /ext/wddx php_wddx_api.h wddx.c"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
From: marty <email protected>
Operating system: Linux
PHP version: 4.0.5
PHP Bug Type: MySQL related
Bug description: Retrieving Random Rows
in response to some of the user contributed notes on the 'rand()' function page, a good way to pull a randmon row from a MySql database ( < ver 3.23 ) is:
SELECT field, field*rand() AS ran FROM table ORDER BY ran LIMIT 1
hope it helps.
-- Edit Bug report at: http://bugs.php.net/?id=10590&edit=1-- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: php-dev-unsubscribe <email protected> For additional commands, e-mail: php-dev-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: Alexander Bokovoy: "[PHP-DEV] Re: [PHP-CVS] cvs: php4 /ext/session php_session.h session.c /ext/wddx php_wddx_api.h wddx.c"
- Previous message: derick <email protected>: "[PHP-DEV] Re: [PHP-CVS] cvs: php4 /ext/session php_session.h session.c /ext/wddx php_wddx_api.h wddx.c"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]