VEs by Curriculum (ever)

<--?php print "

VEs by Curriculum (ever)

\n"; db_set_active('artistworks'); $sql = "SELECT c.name, count(*) FROM `mediaHeader_mediaFamily` mhmf join mediaFamily_mediaGroup mfmg on mfmg.mediafamilyid=mhmf.mediafamilyid join mediaGroup_mediaDepartment mgmd on mgmd.mediagroupid=mfmg.mediagroupid join mediaDepartment_curriculum mdc on mdc.mediadepartmentid=mgmd.mediadepartmentid join curriculum c on c.id=mdc.curriculumid where mhmf.relType='artist_response' and (curriculumid <= 138 or curriculumid >= 147) group by curriculumid order by curriculumid"; $result = db_query($sql); while ($row = db_fetch_array($result)) { print implode("\t\t", $row) . "
\n"; } ?>