<?php
// Allows Addition of Solutions to Knowledgebase

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

// Connect to Database
require_once ('../includes/mysql_connect.php');

// Set Page Title and Include HTML Header
$page_title = 'Helpdesk Over Web - Knowledgebase Admin';
include_once('../includes/header.html');

echo "<H1>Add Knowledgebase Entry</H1>";
echo "<FORM METHOD='POST' ACTION='add-process.php'>";
echo "<P><B>Category:</B> &nbsp;&nbsp;<select name='category'>";
	$sql = "SELECT * FROM kbcategories ORDER BY CategoryText;";
	$catlist = mysql_query($sql)
	   or die("Invalid query: " . mysql_error());
	while($i = mysql_fetch_row($catlist)) 
		{ 
		echo "<OPTION>$i[1]</OPTION>";
		}
echo "</SELECT>";
echo "<P><B>Title:</B> &nbsp;&nbsp;<input type='text' name='title' maxlength='100' size='50'></P>";
echo "<P><B>Keywords:</B> &nbsp;&nbsp;<input type='text' name='keywords' maxlength='100' size='50'></P>";
echo "<P><B>Problem:</B> &nbsp;&nbsp;<BR><textarea name='problem' cols='60' rows='5'></textarea></P>";
echo "<P><B>Solution:</B> &nbsp;&nbsp;<BR><textarea name='solution' cols='60' rows='5'></textarea></P>";
echo "<input type='submit' value='Submit Changes'>";
echo ("<H5>[ <A HREF='kbadmin.php'>Knowledgebase Administration</A> ]</H5>");
echo ("<H5>[ <A HREF='../index.php'>Main System Menu</A> ]</H5>");
// Include HTML footer.
include_once('../includes/footer.html');
?>