NYCPHP Meetup

[tom at supertom.com]

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