用于为每个用户选择随机列数据的PHP代码

Question

PHP code:

$result = executeQuery("select * from question where testid=" . $_SESSION['testid'] . " order by qid;");

the above code select same sequence of questions for every user I want the sequence of questions to be changed every time the user start the test

Answer 1

you can use random function in order by.

 ORDER BY RAND()

 $result = executeQuery("select * from question where testid=" . $_SESSION['testid'] . " order by RAND();");