\n";
$psql="select type,image,jobnumber,`secondary` from (select `primary` as type,image,jobnumber,`secondary` from imagedb where gallery = 'yes' order by RAND()) as subquery group by type";
$presult=$db->query($psql);
while ( $prow=$presult->fetch() ) {
$pname = $prow['type'];
$secondary = $prow['secondary'];
$pcname = $prow['image'];
$pjobn = $prow['jobnumber'];
$dir = "../imageassets/project-top/ch-level/$pjobn/$pcname";
$p = str_replace(' ', '%20', $pname);
//echo $p;
if ($secondary == "No secondary") {
$slink = "sectiona/".$p.".html";
} else {
$slink = "section/".$p.".html";
}
$rowcnt++;
if(($rowcnt)%4==1) {
$xtra .="
\n";
} else {
$xtra .="
\n";
}
if(($rowcnt)%4==0) $xtra .="