Click Next Button to get the new MySQL Record

[NaniG]

Hi to all,

 

        Am developing a Online Test Quiz Portal.

 

My Question is :

 

When the user clicks on next button ( very first time ), how can i get the next question which is to be not in previous question id in the present question id.

 

Here is the mySQL select statement...

select * from questions where TESTTOPIC_ID in (1, 5) and QSTATUS = 'Enable' and QID NOT IN ('10') order by rand() limit 0,1;

Here suppose

TestTopic Id 1 -> PHP

                    5 -> CSS

 

QID Question ID

 

When i run above script it will shows only one record. it is fine.

But how can i add the previous question id into an array (in QID) to cross check whether the question is already shown in the list.

 

Please help me out.

 

 

 

 

[cyberRobot]

The previously shown question IDs could be stored in a session variable. More information about sessions can be found here:

http://www.php.net/manual/en/book.session.php