Dear all can I view a pop3 mail account without using IMAP? If there is can someone point me to such a resource the function imap_open() will not work on my cgi server Thanks Colm Rafferty
-----Original Message----- From: Christian Dechery [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 11, 2001 01:35 To: HEW Staff; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] Random Row From Database try this... select * from tablename order by rand() limit 1 it works perfectly... at least for my needs... At 15:18 11/11/01 +1100, 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. > >However, there are 19 rows in the database and only the first row ever shows >up. > >Is there a way to do this to ensure uniqueness? > >The code I am using at the moment also filters so that rows are pulled from >the database given certain other criteria such as: > >SELECT * FROM TABLENAME WHERE PayerID=$id AND RAND() LIMIT 1 > >All of the rows in the database contain the same PayerID and this column is >not the Primary Key. > >Any help much appreciated. >Jonathan S Hardiman >President/CEO >Hardiman Enterprises Worldwide > > > >-- >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] _____________________________ . Christian Dechery . . Gaita-L Owner / Web Developer . . http://www.webstyle.com.br . . http://www.tanamesa.com.br -- 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] -- 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]