<?php

// Solutions Knowledgebase Admin Menu

// Include Configuration File
require_once ('../includes/config.inc'); 

// Set the page title and include the HTML header.
$page_title = 'Helpdesk Over Web - Solutions Knowledgebase';
include ('../includes/header.html');

// Connect to Database
require_once ('../includes/mysql_connect.php');
	
// Output query results in a table.
echo ("<H1>Solutions Knowledgebase</H1>");
echo ("<P>Administration options are shown in the menu below. To edit or delete an existing entry, first browse or search the existing solutions.<UL>
<H4><A HREF='add.php'>Add Solution</A></H4>
<H4><A HREF='browseall.php'>Browse All Knowledgebase Solutions</A></H4>
<H4><A HREF='kbsearch.php'>Search Knowledgebase</A></H4>
</UL>
<H4>Useful Links</H4>");
$linkssql = "SELECT URL, Title FROM usefullinks ORDER BY Title";
$linkslist = mysql_query($linkssql)
   or die("Invalid query: " . mysql_error());
   while($i = mysql_fetch_row($linkslist)) { 
   	echo "<UL><A HREF=$i[0] TARGET='_new'>$i[1]</A></UL>";
	}
echo "<P>[ <A HREF='../index.php'>Main Menu</A> ]</P>";
// Include standard HTML footer
include ('../includes/footer.html');
?>