Online Exam

[balamurugan]

I am coding for a online exam using php.. there will be 100 questions in the database... for each user it must show different question selecting randomly from the database... for each page it will display 10 question for a period... after that it will go for next page... in this way all the 100 question will be displayed.... finaly the result must shown... this is the concept...

The pbm is i am able to show 1 question for a page... how to display and getting the ans for 10 question... can anyone help me? if already anyone did like this please help me in this reg...

Regs
bala

[ftrudeau]

In your sql code, add the LIMIT query ;

SELECT * FROM your_table where some_condition LIMIT 0,10

You will grab the first 10 results.

Now, if you need to disaply 10 quest. per page, up until 100 questions, you will need to grab data from sql again, like this, everytime ;

SELECT FROM your_table where some_condition LIMIT 11,20
SELECT FROM your_table where some_condition LIMIT 21,30
SELECT * FROM your_table where some_condition LIMIT 31,40

And on and on.

Hope this helps.

[Arc]

That doesnt work with SQL server though.. You'll Have to use TOP instead.

SELECT TOP 10 * FROM your_table where some_condition

The problem with that is i dont know how to do an offset with TOP...such as, select top 10 starting at 11 etc..