RE: [PHP] random order
| From: | John Holmes | Date: | Sun, 12 May 2002 21:21:32 +0000 |
| Subject: | RE: [PHP] random order | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-97230@lists.php.net to get a copy of this message | ||
Nothing to do with PHP...
SELECT * FROM table ORDER BY RAND();
---John Holmes...
> -----Original Message-----
> From: Jule [mailto:jslootbeek@clarku.edu]
> Sent: Sunday, May 12, 2002 9:49 AM
> To: php-general@lists.php.net
> Subject: [PHP] random order
>
> Hey guys and gals,
> I have a problem:
> I have a mysql databse with 4 rows, and each row (row1, row2, row3,
and
> row4)
> contains a sentence. now i want these sentences to appear in random
order:
> instance: 1 2 etc.
> row2 row4
> row4 row2
> row1 row1
> row3 row3
>
> how do i go about that??
> any ideas apreciated.
> thanks
>
> Jule
> --
> |\/\__________________________/\/|
> | Jule Slootbeek |
> | jslootbeek@clarku.edu |
> | http://blindtheory.cjb.net |
> | __________________________ |
> |/\/ \/\|
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php