yes... I hard coded the values and they still don't work:
my $request = "SELECT * FROM dbname WHERE unit = ? AND name1 REGEXP ?
+AND email REGEXP ? ORDER BY unit"
my $dbh = DBI->connect("DBI:mysql:database=database;host=localhost", "
+user", "passwd",{'RaiseError' => 1});
my $sth = $dbh->prepare($request);
$sth->execute("001", "duckman", "google.com");
while (my $ref = $sth->fetchrow_hashref())
{
# here is where the magic happens
h3("this should be running but isn't");
h3("Unit $ref->{'unit'}");
}
I guess I need to learn how to do my SQL differently.