in reply to Re: sth fetch only grabbing back first result
in thread sth fetch only grabbing back first result

I don't think it can be my data because I'm just storing the time as a timestamp.
my $data = qq(INSERT INTO searches (search, engine, time) values(?,? +,NOW())); my $sth = $dbh->prepare($data); $sth->execute("$search", "$engine");
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.
"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) )");
Thank you.