[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