$dbh = DBI->connect("DBI:mysql:$database:$db_server", $user, $password);

     {
	  $statement = "SELECT id,state,city,discription FROM speedtrap WHERE state=$state";
      }

$sth = $dbh->prepare($statement) or die "Couldn't prepare the query: ".$sth->errstr;
$rv = $sth->execute or die "Couldn't execute query: ".$dbh->errstr;

print <<EOF;
<table border="1" align="center" width="100%">
    <tr>
        <td width="1" height="1">
            <p align="center">ID</p>
        </td>
        <td width="10%" height="1">
            <p align="center">State</p>
        </td>
        <td width="20%" height="1">
            <p align="center">City</p>
        </td>
        <td width="20%" height="1">
            <p align="center">Location</p>
        </td>
        <td width="20%" height="1">
            <p align="center">Discription</p>
        </td>
            </tr>
EOF

while (@row = $sth->fetchrow_array) {
($id,$state,$city,$Discription) = @row;


print <<EOF;
<tr>
        <td width="1" height="1>$id</td>
        <td width="10%" height="1">$state</td>
        <td width="20%" height="1">$city</td>
        <td width="20%" height="1">$location</td>
        <td width="70%" height="1">$discription</td>
    </tr>

EOF
}
print "</table>";
}

$rc = $sth->finish;
$rc = $dbh->disconnect;