ORDER BY RAND()
Russ
-Original Message-
From: David Robley [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 12, 2002 1:08 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Random
In article <003601c241ad$225775e0$[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> can someone h
In article <003601c241ad$225775e0$[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> can someone help me to generate a random records from the database?
> eg,
>
> rec 1 john doe
> rec 2 jay williams
> rec 3 anie boo
>
> random results:
>
> rec 2 jay williams
> rec 1 john doe
> rec 3 anie boo
>
>
> "Adam Lundrigan" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> What i need to do is select 10 questions from a database
> (db: vpt, table: questions), and make sure that the same
> question doesn't appear twice. The questions need to
> appear in a random
