انا عندي اسكربت وفي الكود دا بيعرض الرو الي قاعده البيانات بس بطريقه عشوائيه وانا عايزه يعرضها بتسلسل
كود PHP:
$stamp = date('mdyHis');
$_SESSION['quiz_date'] = date('d-M-y ,D');
$_SESSION['quiz_time'] = date('H:i:s');
$_SESSION['quiz_id'] = $stamp;
$_SESSION['full_name'] = $_POST['name_full'];
$_SESSION['email'] = $_POST['email_id'];
$_SESSION['quiz_total_question'] = $_POST['total_question'];
$_SESSION['quiz_time_sec'] = $_POST['time'] * 60; // time in seconds
$_SESSION['quiz_time_min'] = $_POST['time'];
$_SESSION['quiz_cat1'] = $_POST['cat1'];
$query = "SELECT * FROM ".$crtp_quiz;
$sql = mysql_query($query);
$total_rows = mysql_num_rows($sql);
$i=0;
array($rand_arr);
while($i < $_SESSION['quiz_total_question'])
{
$rand_num = rand(1,$total_rows - 1);
if(!@array_search($rand_num,$rand_arr))
{
$rand_arr[$i] = $rand_num;
$i++;
}
}
global $quiz_data;
for($i=0;$i < $_SESSION['quiz_total_question'];$i++)
{
$query = "SELECT * FROM ".$crtp_quiz." WHERE id = ".$rand_arr[$i];
$sql = mysql_query($query);
$quiz_data[$i] = mysql_fetch_array($sql);
}
$_SESSION['quiz_data']=$quiz_data;