Not quite sure I understand, but to select a single record at random: record = db(db.mytable).select(limitby=(0, 1), orderby='<random>').first()
To create an update form for a record, you can then do: form = SQLFORM(db.mytable, record) Anthony On Wednesday, April 4, 2012 2:10:52 PM UTC-4, Sonu Srivastava wrote: > > i have a table in database and i want to fetch record one by one randomly > from database on form...every record is shown on form with radio button and > when user select one of them and click on submit button then next record > will be shown on the form... > so..please help me for this code... >
