i.e.
43  $sth=$dbh->prepare("select * from people where name=?");
44  $sth->execute($name);                                      
45  my @ar = $sth->fetchrow_array();                            
46          foreach $ar (@ar) {                                 
47                  print "$ar \n";                             
48          }                                                   
49  $sth->finish; 

##</code><code>##

name doug
last mitchell
phone 1234567
address house
colour blue

##</code><code>##

doug
mitchell
1234567
house
blue