<?php
    $query = $db -> execute ( "SELECT c.id, c.location, c.ppw, c.berth, c.description, GROUP_CONCAT( g.image SEPARATOR  ' , ' ) as images FROM caravans AS c LEFT JOIN gallery AS g ON g.cid = c.id GROUP BY c.id LIMIT 10" );

    while ( $row = $db -> fetchassoc ( $query ) )
    {
        echo '<strong>CARAVAN ID</strong>: ' . $row [ 'id' ] . '<br />';
        echo '<strong>CARAVAN LOC</strong>: ' . $row [ 'location' ] . '<br />';
        echo '<strong>CARAVAN PPW</strong>: ' . $row [ 'ppw' ] . '<br />';
        echo '<strong>CARAVAN BERTH</strong>: ' . $row [ 'berth' ] . '<br />';
        echo '<strong>CARAVAN DESC</strong>: ' . $row [ 'description' ] . '<br />';
        echo '<strong>CARAVAN IMAGES</strong>: ' . $row [ 'images' ];
        echo '<br /><br />';
    }
?>