On Saturday 18 May 2002 18:00, you wrote:
> yeah i tried doing that in phpMyAdmin, and it gave me an error
> and when i use
>
> SELECT * FROM 4172_questions ORDER BY RAND() LIMIT $row
>
> ($row being the number of rows)as my query it gives me the:
>
> Warning: Supplied argument is not a valid MySQ
uery would work in other database programs, too.
---John Holmes...
> -Original Message-
> From: Neil Zanella [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, May 12, 2002 9:13 PM
> To: John Holmes
> Cc: 'Jule'; PHP General Mailing List; MySQL Mailing List
> Subjec
t; Sent: Sunday, May 12, 2002 1:28 PM
> > To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> > [EMAIL PROTECTED]
> > Subject: Re: [PHP] random order
> >
> > hmm it got a little more complicated now,
> > i have a table with: id title question answer1 answer2 answer3
> answ
is up into two
tables.
---John Holmes...
> -Original Message-
> From: Jule [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, May 12, 2002 1:28 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: Re: [PHP] random order
>
> hmm it got a little mor
u'd use this:
>
> SELECT * FROM table ORDER BY RAND() LIMIT 4;
>
> ---John Holmes...
>
> > -Original Message-
> > From: Jule [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, May 12, 2002 11:22 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [PHP] random o