Re: PHP GUI? - MySQL Rand() FOR RANDOMIZING
| From: | Mike Flynn | Date: | Wed, 07 Nov 2001 18:55:53 +0000 |
| Subject: | Re: PHP GUI? - MySQL Rand() FOR RANDOMIZING | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-10277@lists.php.net to get a copy of this message | ||
I already answered this a few hours ago. MySQL has a built-in Rand() function.
For example,
$query = 'SELECT intPictureID FROM tblPictures ';
$query .= 'ORDER BY Rand()';
At 08:41 PM 11/6/01 -0600, you wrote:
>Now that would be sweet!
>
>I am interested in how I would write a query to mysql that would randomize a
>selection...
>
>i.e.
>I have a table list full of qoutes from famous people and wanted to
>randomize them that a different would show..
>
>How would I do that? I did it in VB with a function called random