<?php require_once('../Connections/admin.php'); ?>
<?php if($_GET['tb']==1)
{
$tablename="card";
}
else if ($_GET['tb']==2){
$tablename="gift";
}
?>
<?php
mysql_select_db($database_admin, $admin);
$query_Recordset1 = "SELECT $tablename_cat.cat_id, <?php echo
$tablename; ?>_cat.cat_name FROM <?php echo $tablename; ?>_cat";
$Recordset1 = mysql_query($query_Recordset1, $admin) or
die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_admin, $admin);
$query_Recordset2 = "SELECT <?php echo $tablename; ?>_subcat.cat_id,
<?php echo $tablename; ?>_subcat.subcat_id, <?php echo $tablename;
?>_subcat.name FROM <?php echo $tablename; ?>_subcat";
$Recordset2 = mysql_query($query_Recordset2, $admin) or
die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<form>
<table width="200" border="1" cellspacing="0" cellpadding="0">
<tr>
<td>Category Name </td>
<td><input type="text" name="cat_name"></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input type="submit" value="Add Category">
</div></td>
</tr>
</table>
</form>
<form>
<p> </p>
<table width="200" border="1" cellspacing="0" cellpadding="0">
<tr>
<td>Sub Category</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>Category</td>
<td><select name="select">
<?php
do {
?>
<option value="<?php echo $row_Recordset1['cat_id']?>"<?php if
(!(strcmp($row_Recordset1['cat_id'], $row_Recordset1['cat_name'])))
{echo "selected=\"selected\"";} ?>><?php echo
$row_Recordset1['cat_name']?></option><?php
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
$rows = mysql_num_rows($Recordset1);
if($rows > 0) {
mysql_data_seek($Recordset1, 0);
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?>.
</select></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input type="submit" name="Submit" value="Add Sub Category">
</div></td>
</tr>
</table>
</form>
<p> </p>
<table width="349" border="1" cellspacing="0" cellpadding="0">
<form action="$addform.php">
<tr>
<td width="131">Category</td>
<td width="212"><select name="select2">
<?php
do {
?>
<option value="<?php echo $row_Recordset1['cat_id']?>"<?php if
(!(strcmp($row_Recordset1['cat_id'], $row_Recordset1['cat_name'])))
{echo "selected=\"selected\"";} ?>><?php echo
$row_Recordset1['cat_name']?></option>
<?php
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
$rows = mysql_num_rows($Recordset1);
if($rows > 0) {
mysql_data_seek($Recordset1, 0);
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?>
</select></td>
</tr>
</form>
<form>
<tr>
<td>Sub Category </td>
<td><select name="select3">
<?php
do {
?>
<option value="<?php echo $row_Recordset2['subcat_id']?>"<?php if
(!(strcmp($row_Recordset2['subcat_id'], $row_Recordset2['name'])))
{echo "selected=\"selected\"";} ?>><?php echo
$row_Recordset2['name']?></option>
<?php
} while ($row_Recordset2 = mysql_fetch_assoc($Recordset2));
$rows = mysql_num_rows($Recordset2);
if($rows > 0) {
mysql_data_seek($Recordset2, 0);
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
}
?>
</select>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
<p> </p>
</form>
</body>
</html>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
