$db=DBI->connect('dbi:mysql:******'); $query = $db->prepare("SELECT * FROM `Tablename` WHERE 1 AND `artnr` = '$link' ORDER BY id DESC LIMIT 0 , 25;"); $query->execute(); while (my @row = $query->fetchrow_array()){ (datas like name etc,*,*) = @row; print "Shoppage" } $query->finish; $db->disconnect();