RE: [PHP] random order by id

> 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? It's best achieved in sql: SELECT ID, Question FROM Questions WHERE Some = Condition ORDER BY RAND() LIMIT

Re: [PHP] random order by id

t a random sample of a set SELECT * FROM table1,table2 WHERE a=b AND c From: Jule <[EMAIL PROTECTED]> > Date: Sat, 18 May 2002 17:41:59 -0400 > To: [EMAIL PROTECTED] > Subject: [PHP] random order by id > > > Hey guys, > i have a db and a table with id and questions > now

[PHP] random order by id

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 a