You can access the results from a query as an array with:
$Recordset->Results
So if you want to get a random record from that result set you could just use:
<?php var_dump(array_rand($rsiPupil->Results)); ?>
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.