Re: random order by id

2002-05-19 Thread Erik Perrhoe \(Computer Consultant\)
ROTECTED]> To: "Jule" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, May 19, 2002 2:55 AM Subject: Re: random order by id > Jule <[EMAIL PROTECTED]> writes: > > > Hey guys, > > i have a db and a table with id and q

Re: random order by id

2002-05-19 Thread Per Andreas Buer
Jule <[EMAIL PROTECTED]> writes: > Hey guys, > i have a db and a table with id and questions > > now i want these questions to be listed in a random order, is there a way to > format my SQL query or do i need some PHP work to? SELECT foo FROM bar ORDER BY rand(); Just to pick one: SELECT foo

Re: [PHP] random order by id

2002-05-18 Thread Jule
> portable between platforms for the same MySQL version. " > > > > Cheers! > > > > Rick > > > > Nobody will ever win the Battle of the Sexes. There's just too much > > fraternizing with the enemy. - Henry Kissinger > > > > > Fro

random order by id

2002-05-18 Thread Jule
Hey guys, i have a db and a table with id and questions now i want these questions to be listed in a random order, is there a way to format my SQL query or do i need some PHP work to? i can ofcourse select a random one, that's no problem, but how do i make sure that that one does not get chosen