my $sth = $dbh->prepare( 
"INSERT INTO member (nickname, password, first_name, last_name, email, country, homepage, im_type, im_id, info)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");

$sth->execute($nickname, $pass1, $firstname, $lastname, $email, $country, $homepage, $imtype, $imid, $info)
   or die "execute failed: $DBI::errstr\n";