echo "<img src='".$row ['url_img']."' onerror='this.onerror=null';this.src='no_img.jpg'  /><br />";

if (isset($_GET['id'])) {
    $sql = "SELECT w.whisky_name
, price
, date
, avprice
,url_img
,whisky_id
FROM test_db t
JOIN
    whisky w USING (whisky_id)
JOIN (
    SELECT whisky_id
    , AVG(price) as avprice
    FROM test_db
    WHERE whisky_id = :id
    GROUP BY whisky_id
    ) avcalc USING (whisky_id)
ORDER BY date DESC
LIMIT 1";

    $stmt = $conn->prepare($sql);
    $stmt->execute( array( 'id' => $_GET['id']) );
    $row = $stmt->fetch();


    echo "<div class='details'>";
        echo "<br>";
        echo $row['whisky_name'];
        echo "<br><br>";
        echo "Average price based on all sales" ;
        echo"<br><br>";
        echo "<div class= 'price'>";
        echo " £";
        echo floor ($row ['avprice']);
        echo "</div>";
        echo "<br>";
        echo "<div class='img_border'>";
        echo "<img src='".$row ['url_img']."' /><br />";
        echo "<a href='records.php?id={$row['whisky_id']}' >Click here for more detailed results</a>";
        echo "<br>";
    echo "</div>";
}
    ?>