OpenConnection();
$sqlCat = "SELECT id, name FROM category WHERE parentCatId is null";
$dbCat->Query($sqlCat);
$dbSubs = &new DbLibMySQL;
$dbSubs->OpenConnection();
$dbOrgs = &new DbLibMySQL;
$dbOrgs->OpenConnection();
?>
View
GetNextRecord()) { ?>
GetField('name');?>
GetField('id');
$dbSubs->Query($sqlSubs);
while($dbSubs->GetNextRecord()) { ?>
GetField('name'); ?>
ResetRecordSet();
while($dbCat->GetNextRecord()) { ?>
GetField('name');?>
GetField('id');
$dbOrgs->Query($sqlOrgs);
while($dbOrgs->GetNextRecord()) { ?>
GetField('name');?>
GetField('description');?>
GetField('phone');?>
GetField('url');?>
GetField('id');
$dbSubs->Query($sqlSubs);
while($dbSubs->GetNextRecord()) { ?>
GetField('name'); ?>
GetField('id');
$dbOrgs->Query($sqlOrgs);
while($dbOrgs->GetNextRecord()) { ?>
GetField('name');?>
GetField('description');?>
GetField('phone');?>
GetField('url');?>