Re: database searching
| From: | Hugh Bothwell | Date: | Mon, 03 Sep 2001 17:39:44 +0000 |
| Subject: | Re: database searching | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-65777@lists.php.net to get a copy of this message | ||
"Melih Onvural" <melih@bellsouth.net> wrote in message
news:HHEKIFCGOCEGCKHMPLEHGEPACAAA.melih@bellsouth.net...
> i want to randomly choose a column in a database with a quote in it, by
the
> number of the column.
> i have a random seed working, but it won't pull only one column, but all
> columns. How can I choose
> just one column, and print one column at a time?
SELECT text FROM quotes ORDER BY RAND() LIMIT 1