// Select all photos
$result = mysql_query("SELECT a.pid, a.aid, a.title, a.caption, a.keywords, b.title atitle from {$CONFIG['TABLE_PICTURES']} a, {$CONFIG['TABLE_ALBUMS']} b where a.aid = b.aid order by a.aid, a.pid desc");
if (!mysql_num_rows($result)) cpg_die(ERROR, $lang_errors['non_exist_ap']);

$p_aid = -1 ;

// Result to table
starttable("100%", Fotoindex, 3);

   while ($row = mysql_fetch_array($result)) 
        { 
                if ($row[aid] != $p_aid) {
                  echo "<tr><td class=\"tableh2\" colspan = \"3\">$row[atitle]</td></tr>" ;
            }
            // weer geef de data 
            echo "<tr><td><a href=\"displayimage.php?pos=-$row[pid]\" title=\"$row[title]\">$row[title]</a></td><td>$row[caption]</td><td>$row[keywords]</td></tr>"; 
       $p_aid = $row[aid] ;
    } ; // while
                
endtable();
pagefooter();
?>