\n";
$psql="SELECT projectid,toplevel from (select projectid,toplevel from jcaprojectdetail where active = 'yes' order by RAND()) as subquery group by toplevel";
$presult=$db->query($psql);
while ( $prow=$presult->fetch() ) {
$ptoplevel = $prow['toplevel'];
$projid = $prow['projectid'];
$psql2="select type,image from (select `primary` as type,image from imagedb where active = 'yes' and jobnumber = '$projid' order by RAND()) as subquery group by type";
$presult2=$db->query($psql2);
while ( $prow2=$presult2->fetch() ) {
$pcname = $prow2['image'];
$dir = "../imageassets/project-top/ch-level/$projid/$pcname";
};
$p = str_replace(' ', '%20', $ptoplevel);
$rowcnt++;
if(($rowcnt)%4==1) {
$xtra .="
\n";
} else {
$xtra .="
\n";
}
if(($rowcnt)%4==0) $xtra .="