Re^3: sth fetch only grabbing back first result

[Ieronim]

Maybe, this happens because NOW() and CURDATE() return date in different formats?

Try

my $data = qq(SELECT search, engine, time FROM searches WHERE DATE_SUB
+(NOW(),INTERVAL 7 DAY) <= time);

I cannot test it now, but i think that it will produce the wanted output too.