Re: [PHP] random order by id

2002-05-18 Thread Jule
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

RE: [PHP] random order

2002-05-13 Thread John Holmes
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

RE: [PHP] random order

2002-05-12 Thread Neil Zanella
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

RE: [PHP] random order

2002-05-12 Thread John Holmes
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

Re: [PHP] random order

2002-05-12 Thread Jule
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