Help for this page

Select Code to Download


  1. or download this
    $sqlstatement="SELECT Table1.Name,  Table1.Address, Table1.City, 
                          Table1.State, Table1.ZIP,     Table1.Phone 
                     FROM Table1 WHERE Table1.BusType = 'ARCHITECTS'";
    $sth = $dbh->prepare($sqlstatement);
    
  2. or download this
    my @lines = <DATA>;
    my $line;
    ...
                          Table1.State, Table1.ZIP,     Table1.Phone 
                     FROM Table1 WHERE Table1.BusType = '$line';
    $sth = $dbh->prepare($sqlstatement);