prepare("SELECT id, soggetto, URI_Watermark, autorefotografia, nomefondo FROM sagidCOPIA WHERE URI_Watermark NOT LIKE '' AND URI_Watermark NOT LIKE '%NOFOTO%' AND autorefotografia NOT LIKE '' AND nomefondo NOT LIKE '' AND nomefondo LIKE '%Gabinetto%' ORDER BY RAND() LIMIT 100"); $stmt->execute();$numrowp = $stmt->rowCount(); if($stmt->rowCount() > 0) { while($row=$stmt->fetch(PDO::FETCH_ASSOC)) { extract($row);?>