my $data = qq(INSERT INTO searches (search, engine, time) values(?,?,NOW())); my $sth = $dbh->prepare($data); $sth->execute("$search", "$engine"); #### "CREATE TABLE IF NOT EXISTS searches ( id int auto_increment NOT NULL, search VARCHAR(150) NOT NULL, engine VARCHAR(20) NOT NULL, time datetime, primary key (id) )");