zen_snippet.php

// *Check to see if someone has clicked on a word out of the description text on the video page.*
// *If they have then do a search for that term.*
if(isset($_GET["term"]))
{
    $termid = $_GET["term"];

    if(is_numeric($termid))
    {
        zpConnectDB('zanesitecontent');
        $sql = "SELECT g.id, g.term, t.name as topic, g.description FROM glossary AS g
                INNER JOIN Topics AS t ON (t.productid = g.topic)
                WHERE g.id = " . mysql_real_escape_string($termid) . "
                    " . ($subject == 0?"":"AND t.subject = " . mysql_real_escape_string($subject)) . "
                    " . ($category == 0?"":"AND t.category = " . mysql_real_escape_string($category)) . "
                    " . ($topic == 0?"":"AND t.productid = " . mysql_real_escape_string($topic)) . "
                ORDER BY t.name, g.term";
        $result = mysql_query($sql) OR $debugContent .= debugMysql(mysql_error(),$sql);

        $rowCount = mysql_num_rows($result);

        while($row = mysql_fetch_array($result))
        {
            array_push($results, array("topic" => $row["topic"], "term"=>$row["term"], "id" => $row["id"], "description" => $row["description"]));
        }
        $smarty->assign('rowCount', $rowCount);
        $smarty->assign('searchResults', $results);
    }

}