با سلام دوستان من میخوام یک آزمون رندوم درست کنم شما فکر کنید که ما 20 سوال یا رکورد داریم در یک جدولمون حالا من کد sql رو می خوام که با هر بار رفرش 20 سوال متقاوت بهم بده
من با دستور in این کار رو کردم ولی یک بار 15 سوال می ده یک بار 10 سوال و یک بار 20 سوال مشکل من اینجاست هر بار 20 تا سوال یا رکورد نمایش بده نه کمتر نه بیشتر
<php>
$number1=rand (1, 30);
$number2=rand (2, 30);
$number3=rand (3, 30);
$number4=rand (4, 30);
$number5=rand (5, 30);
$number6=rand (6, 30);
$number7=rand (7, 30);
$number8=rand (8, 30);
$number9=rand (9, 30);
$number10=rand (10,30);
$number11=rand (11, 30);
$number12=rand (12, 30);
$number13=rand (13, 30);
$number14=rand (14, 30);
$number15=rand (15, 30);
$number16=rand (16, 30);
$number17=rand (17, 30);
$number18=rand (18, 30);
$number19=rand (19, 30);
$number20=rand (20, 31);
$number21=rand (21, 30);
$number22=rand (22, 30);
$number23=rand (23, 30);
$number24=rand (24, 30);
$number25=rand (25, 30);
$number26=rand (26, 30);
$number27=rand (27, 30);
$number28=rand (28, 30);
$number29=rand (29, 30);
$number30=rand (30, 31);
$Qsoal=@mysql_query("select * from regexam where cod_exam='$idnew' && id IN('$number1','$number2','$number3','$number4','$number5','$number6','$number7','$number8','$number9','$number10','$number11','$number12','$number13','$number14','$number15','$number16','$number17','$number18','$number19','$number20','$number21','$number22','$number23','$number24','$number25','$number26','$number27','$number28','$number29','$number30') limit 1,20");
while($fsoal=@mysql_fetch_array($Qsoal))
{
echo $fsoal[textsoal]
}
<php/>
من با دستور in این کار رو کردم ولی یک بار 15 سوال می ده یک بار 10 سوال و یک بار 20 سوال مشکل من اینجاست هر بار 20 تا سوال یا رکورد نمایش بده نه کمتر نه بیشتر
<php>
$number1=rand (1, 30);
$number2=rand (2, 30);
$number3=rand (3, 30);
$number4=rand (4, 30);
$number5=rand (5, 30);
$number6=rand (6, 30);
$number7=rand (7, 30);
$number8=rand (8, 30);
$number9=rand (9, 30);
$number10=rand (10,30);
$number11=rand (11, 30);
$number12=rand (12, 30);
$number13=rand (13, 30);
$number14=rand (14, 30);
$number15=rand (15, 30);
$number16=rand (16, 30);
$number17=rand (17, 30);
$number18=rand (18, 30);
$number19=rand (19, 30);
$number20=rand (20, 31);
$number21=rand (21, 30);
$number22=rand (22, 30);
$number23=rand (23, 30);
$number24=rand (24, 30);
$number25=rand (25, 30);
$number26=rand (26, 30);
$number27=rand (27, 30);
$number28=rand (28, 30);
$number29=rand (29, 30);
$number30=rand (30, 31);
$Qsoal=@mysql_query("select * from regexam where cod_exam='$idnew' && id IN('$number1','$number2','$number3','$number4','$number5','$number6','$number7','$number8','$number9','$number10','$number11','$number12','$number13','$number14','$number15','$number16','$number17','$number18','$number19','$number20','$number21','$number22','$number23','$number24','$number25','$number26','$number27','$number28','$number29','$number30') limit 1,20");
while($fsoal=@mysql_fetch_array($Qsoal))
{
echo $fsoal[textsoal]
}
<php/>
