Skip to Content
0
Former Member
Apr 13, 2010 at 08:14 AM

Random data from the database table

70 Views

Hi

I need to obtain random data from the database table.

I have got a table which has got Questionid, Question, Option1, Option2, Option3, Option4, Answer as fields.

This table has got 100 questions I need to obtain 30 records from this table randomly and display that 30 records in new table say "A" with the same fields. Every time I need to obtain different records and put that in that table "A".

The size of this table can change now it is 100 but later it came be 150 or it can be 50 also.

Please provide with solution code.

Thanking You,

Swapnil