$sth->bind_columns(\($siteid, $imageurl));
while($sth->fetch()) {
    $sites{$siteid} = $imageurl;
}
$count = keys %sites;