'0')
{
//get the subcategory name
$q3 = "select SubcategoryName from dd_subcategories where SubcategoryID = '$a1[ItemSubcategory]' ";
$r3 = mysql_query($q3) or die(mysql_error());
$a3 = mysql_fetch_array($r3);
$Item_Category .= "/$a3[0]";
}
$Item_Contributor = $a1[Contributor];
//get the rating
$q4 = "select count(ItemID) as n, sum(Rating) as r from dd_rating where ItemID = '$a1[ItemID]' ";
$r4 = mysql_query($q4) or die(mysql_error());
$a4 = mysql_fetch_array($r4);
if($a4[n] > '0')
{
$Item_Rating = number_format($a4[r]/$a4[n], 2, ".", "");
}
else
{
$Item_Rating = "0.00";
}
$View_Item .= "$a1[ItemTitle]
";
$View_Link .= "";
$VenInfo = explode("|", $a1[ItemText]);
$View_Item .= nl2br($VenInfo[0])."
";
if(!empty($a1[ItemImage]))
{
$MySize = getimagesize("../../teachers/resources/worksheets/items_images/$a1[ItemImage]");
if($MySize[0] > '150')
{
$MyWidth = '150';
}
else
{
$MyWidth = $MySize[0];
}
$View_Item .= "![](\"../../teachers/resources/worksheets/items_images/$a1[ItemImage]\")
";
}
$View_Item .= nl2br($VenInfo[1]);
if($_GET[rate_error] == "y")
{
$message = "Sorry, you have already rated this $main_keyword.";
}
elseif($_GET[rate_error] == "n")
{
$message = "Thank you for rating this $main_keyword.";
}
//get the templates
require_once("templates/MainHeader.php");
require_once("templates/MainView.php");
require_once("templates/MainFooter.php");
?>