php webmail
| From: | Colm Rafferty | Date: | Sun, 11 Nov 2001 13:40:12 +0000 |
| Subject: | php webmail | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-74170@lists.php.net to get a copy of this message | ||
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:cdechery@easynet.com.br]
Sent: Sunday, November 11, 2001 01:35
To: HEW Staff; php-db@lists.php.net; php-dev@lists.php.net;
php-general@lists.php.net
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: php-general-unsubscribe@lists.php.net
>For additional commands, e-mail: php-general-help@lists.php.net
>To contact the list administrators, e-mail: php-list-admin@lists.php.net
_____________________________
. 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: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net