I have a script that print test questions and grades them... how do I make them print a random order

I have a script that print test questions and grades them... how do I make
them print a random order, and a certain amount ??  
 
code 
@@@@@@@@@@@@@@@@
 

$dbh =DBI ->connect($data_source, $username, $password) or die "cant connect
to
$data_source : my $dbh-> errstr\n";
 
 
my $sth1 = $dbh -> prepare("select * from tests where subject = '$test' ");
$sth1 -> execute or die " unable to execute query ";
#$sth1 -> finish;
 
 
##################
 
the table 
mysql> show columns from tests;
+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| num     | int(5)       |      | PRI | NULL    | auto_increment |
| subject | varchar(200) | YES  |     | NULL    |                |
| ques    | longtext     | YES  |     | NULL    |                |
| quesA   | longtext     | YES  |     | NULL    |                |
| quesB   | longtext     | YES  |     | NULL    |                |
| quesC   | longtext     | YES  |     | NULL    |                |
| quesD   | longtext     | YES  |     | NULL    |                |
| quesE   | longtext     | YES  |     | NULL    |                |
| ans     | varchar(20)  | YES  |     | NULL    |                |
| corr_a  | char(2)      | YES  |     | NULL    |                |
| corr_b  | char(2)      | YES  |     | NULL    |                |
| corr_c  | char(2)      | YES  |     | NULL    |                |
| corr_d  | char(2)      | YES  |     | NULL    |                |
| corr_e  | char(2)      | YES  |     | NULL    |                |
| exp     | longtext     | YES  |     | NULL    |                |
| pipe    | varchar(20)  | YES  |     | NULL    |                |
+---------+--------------+------+-----+---------+----------------+
16 rows in set (0.00 sec)
 
mysql>

 
 
 
thanks 
Jim
 
 

• I have a script that print test questions and grades them... how do I make them print a random order by FLAHERTY, JIM-CONT