How to Query the Databse?

[Ascendancy]

I am interested in creating a tpl-functions.php file in my theme's main directory and then including it into the header section, just to load some simple page functions I want to try out. Would I need to open a new database connection or would it still be open if I included the file this way, and if it's not do you know what file I can check out to see how to connect to the Pligg DB?

[Ascendancy]

Bump, hopefully someone could hold the answer?

[lowster11]

I believe that you just query:

<script src="{$my_pligg_base}/modules/jquery/js/jquery.js" type="text/javascript"></script>

<script src="{$my_pligg_base}/modules/jquery/js/jquery.autoresize.js" type="text/javascript"></script>
<script src="{$my_pligg_base}/modules/jquery/js/jquery.fancybox.js" type="text/javascript"></script>
<link rel="stylesheet" href="{$my_pligg_base}/modules/jquery/css/fancybox.css" type="text/css" media="screen">
{literal}
<script type="text/javascript">
    $(document).ready(function() { $("a#single_image").fancybox(); $("a#inline").fancybox({ 'hideOnContentClick': false }); $("a.group").fancybox({ 'zoomSpeedIn': 200, 'zoomSpeedOut': 200, 'overlayShow': false }); }); 
</script>
{/literal}

[Ascendancy]

Well all of that code is just JavaScript and CSS... What I was trying to do was edit the sidebar module by querying the database. Currently my sidebar shows short title's of stories, which is good because it saves space. However I want to make it so when people hover over the link, the tooltip shows the full story title. I can't seem to find a readily-saved variable in the sidebar modules for the full story's title, so I am looking to just query the DB and grab it myself