NYCPHP Meetup

NYPHP.org

[nycphp-talk] Random record from MySQL

Jeff Siegel jsiegel1 at optonline.net
Thu Mar 11 10:53:26 EST 2004


Boy...that was easy enough.

Jeff

tom at supertom.com wrote:

> Jeff,
> 
> Try:
> 
> SELECT  * FROM table_name ORDER  BY RAND(  ) LIMIT 0 , 1
> 
> Tom
> www.liphp.org
>  
>  
>  
>  
> ***************************************************
> What's Tom listening to right now?  Find out here:
> http://www.supertom.com/current_track.php
> 
> 
> 
> 
> -----Original Message-----
> From: talk-bounces at lists.nyphp.org
> [mailto:talk-bounces at lists.nyphp.org]On Behalf Of Jeff Siegel
> Sent: Thursday, March 11, 2004 10:32 AM
> To: NYPHP Talk
> Subject: [nycphp-talk] Random record from MySQL
> 
> 
> How can I pull a record at random from a MySQL table?
> 
> Jeff Siegel
> 
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
> 
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
> 




More information about the talk mailing list