On Sunday 11 November 2001 05:18, HEW Staff wrote: > Hi, > > I'm trying to pull a random row from my database and display the > contents. > > I know that the code: > SELECT * FROM TABLENAME WHERE RAND() LIMIT 1 > should work.
(1) [EMAIL PROTECTED] has nothing to do with this. So don't crosspost to there. (2) No, it shouldn't work "WHERE RAND ()" means "where some random number evaluates to true (i.e. is nonzero)" you want "ORDER BY RAND () LIMIT 1" -- Christian Reiniger LGDC Webmaster (http://lgdc.sunsite.dk/) ...10001000110101011010101101011110111010113...???? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
