in reply to Re: sth fetch only grabbing back first result
in thread sth fetch only grabbing back first result
search and engine are irrelevant right now, it's just time that's not coming back I'm assuming. The time column is of datetime and this is all I used to set it all up.my $data = qq(INSERT INTO searches (search, engine, time) values(?,? +,NOW())); my $sth = $dbh->prepare($data); $sth->execute("$search", "$engine");
Thank you."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) )");
|
|---|