faq_admin_cat_edit.php at FAQMasterFlex

<?php include "admin_authorize.php" ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>

<title>FAQMasterFlex: Edit Category</title>

<META HTTP-EQUIV="expires" CONTENT="0">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">

<link rel="stylesheet" type="text/css" href="style.css">

<script>
<!--
function wait(delay){
   string="pauseforalert("+delay+");";
   setTimeout(string,delay);
}

function pauseforalert(delay){
   this.window.close();
   opener.location='faq_admin.php';
}
// -->
</script>

</head>
<body <?php

if ($yes) {
   print "onload=\"wait(2000);\"";
}

?>>


<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
   <tr>
	<td class="poptop" height="15"><img src="images/spacer.gif" width="3" height="3"></td>
   </tr>
   <tr>
	<td class="hrz_line"><img src="images/spacer.gif" width="1" height="1"></td>
   </tr>
   <tr>
	<td style="background: #ffffff; padding: 5px" valign="middle"><h1 style="margin-top: 0; margin-bottom: 0">FAQMasterFlex</h1></td>
   </tr>
   <tr>
	<td class="hrz_line"><img src="images/spacer.gif" width="1" height="1"></td>
   </tr>
   <tr>
	<td valign="top" style="padding: 1em" class="maincontent" height="200">
	

	<h2>Category Edit</h2>

        <?php
        
        include "faq_config.php";
        
         if ($update) {
            $result = mysql_query("UPDATE faqcategories SET category = '$category' WHERE id = '$id'") or die(mysql_error());
            print "<h3>Category Successfully Updated</h3>\n";
         }
         elseif ($select) {
            $result = mysql_query("SELECT * FROM faqcategories WHERE id = '$edit'") or die(mysql_error());
            $row = mysql_fetch_array($result);

            print "<form action=\"$_SERVER[PHP_SELF]\" method=\"post\">\n";
            print "<p><strong>Category Name:</strong> <input type=\"text\" name=\"category\" class=\"textfield\" size=\"40\" value=\"$row[category]\"></p>\n";
            print "<input type=\"hidden\" name=\"id\" value=\"$row[id]\">\n";
            print "<input type=\"hidden\" name=\"yes\" value=\"close\">\n";
            print "<input type=\"submit\" name=\"update\" value=\"update\" class=\"submit\">\n";
            print "<input type=\"submit\" name=\"cancel\" value=\"cancel\" class=\"submit\" onclick=\"self.close()\">\n";
            print "</form>\n";
         }
         else {
            $result = mysql_query("SELECT * FROM faqcategories ORDER BY category") or die(mysql_error()); 
            print "<form action=\"$_SERVER[PHP_SELF]\" method=\"post\">\n";
            print "<p><nobr><strong>Category:</strong>\n";
            print "<select class=\"drop2\" name=\"edit\">\n";

            while ($row = mysql_fetch_array($result)) {
               print "<option value=\"$row[id]\">$row[category]</option>\n";
            }
            
            print "</select>\n";
            print "<input type=\"submit\" name=\"select\" value=\"edit\" class=\"submit\">\n";
            print "<input type=\"submit\" name=\"cancel\" value=\"cancel\" class=\"submit\" onclick=\"self.close()\">\n";
            print "</nobr></p>\n";
            print "</form>\n";
         }
         
         mysql_close($link);
        

        ?>

	</td>
   </tr>
   <tr>
	<td class="hrz_line"><img src="images/spacer.gif" width="1" height="1"></td>
   </tr>
   <tr>
	<td height="20" class="popbot"><a href="javascript:window.close()">close</a></td>
   </tr>
</table>

</body>
</html>