include_once("appset05/base.php");
$ft->standardStartPage();
?>
Cowles Data Repository
switch ($_GET["ctl"])
{
case "":
$db->dbSelectQuery("select cid, cname, cdescription from categories "
. "where cactive = 'yes' order by dseq ASC", __LINE__, __FILE__);
$x = mysql_num_rows($db->sresult);
$i = 1;
?>
Each link below represents an assessment activity performed at Cowels Library. Assessment activities relate to one or more goals outlined in the Cowles Library Strategic Plan and/or standards set forth by the Association of College and Research Libraries (ACRL).
while ($row = mysql_fetch_assoc($db->sresult))
{
$cats[$i]["cid"] = $row["cid"];
$cats[$i]["cname"] = $row["cname"];
$cats[$i]["cdescription"] = $row["cdescription"];
if ($i < $x)
{
$i = $i + 1;
}
}
for ($n=1; $n <= $x; $n++)
{
?>
= $cats[$n]["cname"]; ?>
= $cats[$n]["cdescription"]; ?>
$cid = $cats[$n]["cid"];
$db->dbSelectQuery("select aid, aname, adescription from activities "
. "where cid = '$cid' order by aname ASC", __LINE__, __FILE__);
while ($row = mysql_fetch_assoc($db->sresult))
{
?>">= $row["aname"]; ?>
if (!$row["adescription"] == "")
{
?>-- = $row["adescription"]; ?>
}
else
{
?>
}
}
?>
}
break;
/*
case "cat":
$db->dbSelectQuery("select * from categories where "
. "cid = '$_GET[cid]'", __LINE__, __FILE__);
$row = mysql_fetch_assoc($db->sresult);
?>
Category: = $row["cname"]; ?>
Description: = $row["description"]; ?>
Back
$db->dbSelectQuery("select * from activities "
. "where cid = '$_GET[cid]' order by aname ASC", __LINE__, __FILE__);
$x = mysql_num_rows($db->sresult);
$i = 1;
while ($row = mysql_fetch_assoc($db->sresult))
{
$acts[$i]["aid"] = $row["aid"];
$acts[$i]["aname"] = $row["aname"];
$acts[$i]["adescription"] = $row["adescription"];
$acts[$i]["afrequency"] = $row["afrequency"];
$acts[$i]["aresponsible"] = $row["aresponsible"];
if ($i < $x)
{
$i = $i + 1;
}
}
for ($n=1; $n <= $x; $n++)
{
$target = $acts[$n]["aid"];
?>
Name: ">= $acts[$n]["aname"]; ?>
Description: = $acts[$n]["adescription"]; ?>
Frequency: = $acts[$n]["afrequency"]; ?>
Responsible: = $acts[$n]["aresponsible"]; ?>
$db->dbSelectQuery("select acrlid from rel_act2acrl where "
. "aid = '$target'", __LINE__, __FILE__);
if ($db->num != "0")
{
while ($row = mysql_fetch_assoc($db->sresult))
{
$acrls[] = $row["acrlid"];
}
while (list($k, $v) = each($acrls))
{
$db->dbSelectQuery("select acrldocid, acrlname from acrl "
. "where acrlid = '$v'", __LINE__, __FILE__);
$row = mysql_fetch_assoc($db->sresult);
?>ACRL Relationships:
"
target = "_blank">= $row["acrlname"]; ?>
}
}
?>
}
break;
*/
case "act":
//display documents on an activity level
// print the heading information for the activity
$db->dbSelectQuery("select * from activities where aid = '$_GET[aid]'", __LINE__, __FILE__);
$row = mysql_fetch_assoc($db->sresult);
?>
- = $row["aname"]; ?>
- Description: = $row["adescription"]; ?>
Frequency: = $row["afrequency"]; ?>
Responsible: = $row["aresponsible"]; ?>
$db->dbSelectQuery("select acrlid from rel_act2acrl where aid = '$_GET[aid]'", __LINE__, __FILE__);
if ($db->num != "0")
{
?>
- ACRL Documents related to this activity:
while ($row = mysql_fetch_assoc($db->sresult))
{
$acrls[] = $row["acrlid"];
}
while (list($k, $v) = each($acrls))
{
$db->dbSelectQuery("select acrldocid, acrlname from acrl "
. "where acrlid = '$v'", __LINE__, __FILE__);
$row = mysql_fetch_assoc($db->sresult);
?>- "
target = "_blank">= $row["acrlname"]; ?>
}
?>
}
else
{
?>
- No ACRL documents are related to this activity.
}
$db->dbSelectQuery("select goalid from rel_act2goal where aid = '$_GET[aid]' order by goalid ASC", __LINE__, __FILE__);
if ($db->num != "0")
{
?>
- Library strategic goals related to this activity:
while ($row = mysql_fetch_assoc($db->sresult))
{
$goals[] = $row["goalid"];
}
while (list($k, $v) = each($goals))
{
$db->dbSelectQuery("select cname from categories "
. "where goalid = '$v'", __LINE__, __FILE__);
$row = mysql_fetch_assoc($db->sresult);
?>- = $row["cname"]; ?>
}
?>
}
else
{
?>
- No Library strategic goals are listed for this activity.
}
$db->dbSelectQuery("select did from rel_act2doc where aid = '$_GET[aid]'", __LINE__, __FILE__);
if ($db->num != "0")
{
?>
- Documents:
while ($row = mysql_fetch_assoc($db->sresult))
{
$dids[] = $row["did"];
}
$count = 0;
while (list($k, $v) = each($dids))
{
$db->dbSelectQuery("select * from documents where did = '$v'", __LINE__, __FILE__);
$row = mysql_fetch_assoc($db->sresult);
$sdocs[$count]["dyear"] = $row["dyear"];
$sdocs[$count]["dname"] = $row["dname"];
$sdocs[$count]["hdname"] = $row["hdname"];
$count = $count + 1;
}
$ret = asort($sdocs);
foreach($sdocs as $key => $value)
{
?>
- = $sdocs[$key]["dyear"]; ?> --
" target="_blank">
= $sdocs[$key]["hdname"]; ?>
}
}
else
{
?>- No documents are available for this activity.
}
?>
Back
break;
}
$ft->standardEndPage();
?>