Hi I've got this code for selecting a number of questions from a db to make a test. It's random and sometimes it selects the same questions and they appear twice in the tests... how can I stop this from happening?

$sql = "SELECT * FROM questions ORDER BY RAND() LIMIT 20";

thanks in advance!

I am not sure but perhaps you can the DISTINCT keyword... E.g. look here...

http://www.google.com/search?hl=en&q=sql+distinct&meta=

Hope it helps, Jacob.

$sql = "SELECT DISTINCT *, id FROM questions ORDER BY RAND() LIMIT 20";

thanks! this code did the trick!!