добавил в БД еще таблицу glcategories с полями gl_id и name_gl_cat по аналогии как в таблице categories id_cat и name_cat, в таблице w_hudi есть id_cat а вот дальше я запутался
_________
девушки
__________
футболки
толстовки
__________
<?php
include_once'auth.php';
include_once'/bd.php';
mysql_query("SET NAMES 'cp1251'");
mysql_query("SET CHARACTER SET 'cp1251'");
error_reporting(0);
?>
<div style="width:700px; margin:0 auto; border:#FF3366 thin solid">
<div>
<div style="width:290px; float:left; border:#0099FF thin solid"> <!--КАТЕГОРИИ-->
<h3>CATEGORIES</h3>
<?php
$sql_cat = "SELECT * FROM categories ORDER BY id_cat ASC";
$query = mysql_query($sql_cat) or exit(mysql_error());
while ($row_cat = mysql_fetch_assoc($query))
{
?>
<p><a href="?id_cat=<?=$row_cat['id_cat']?>&name_cat=<?=$row_cat['name_cat']?>"><?=$row_cat['name_cat']?></a></p>
<?php
}
?>
</div> <!--КАТЕГОРИИ-->
<div style="width:400px; float:right; border:#CCFF00 thin solid"> <!--ВВОД КАТЕГОРИЙ-->
<?php
if(isset($_GET['id_cat'])){
?>
<h4 style="border-bottom:1px dashed">Number category<span style="color:#FF0000"><?=$id_cat?></span></h4>
<?php
echo $id_cat = $_GET['id_cat'];
echo '<br/>';
$name_cat = $_GET['name_cat'];
echo '<br/>';
?>
<h4 style="border-bottom:1px dashed">SELECT category -<span style="color:#FF0000"><?=$name_cat?></span></h4>
<h5 style="border-bottom:1px dashed">MODELS</h5>
<?php
$sql_mod = "SELECT * FROM w_hudi WHERE id_cat='$id_cat'";
$query_mod = mysql_query($sql_mod) or exit(mysql_error());
while ($row_mod = mysql_fetch_assoc($query_mod))
{
?>
<p><a href="?id=<?=$row_mod['id']?>"><?=$row_mod['name_mod']?></a></p>
<?php
}// while
}// $_GET
if(isset($_GET['id']))//id model
{
echo $id_mod = $_GET['id'];
$sql_mod = "SELECT * FROM w_hudi WHERE id='$id_mod'";// vibiraem tovar
$query_mod = mysql_query($sql_mod) or exit(mysql_error());
while($row_mod = mysql_fetch_assoc($query_mod))
{
?>
<form action="update_mod_save.php" method="post">
<label>EDITING MODELS OPTION</label><br /><br />
<label>Editing category this model</label><br /><br />
<select name="id_cat">
<?php
$sql_cat = "SELECT * FROM categories ";
$query_cat = mysql_query($sql_cat) or exit(mysql_error());
while($row_cat=mysql_fetch_assoc($query_cat)){
if($row_mod['id_cat'] == $row_cat['id_cat']){
?>
<option value="<?=$row_cat['id_cat']?>" selected="selected"><?=$row_cat['name_cat']?></option>
<?php
}else{
?>
<option value="<?=$row_cat['id_cat']?>"><?=$row_cat['name_cat']?></option>
<?php
}
}
?>
</select><br /><br />
<label>Editing model</label><br/>
<textarea name="name_mod" cols="40" rows="5"><?=$row_mod['name_mod']?></textarea><br /><br />
<label>Editing price</label><br/>
<input name="price_mod" type="text" value="<?=$row_mod['price']?>"/>RB.<br/>
<input name="id_mod" type="hidden" value="<?=$row_mod['id'];?>" />
<input name="submit" type="submit" value="update model" />
</form>
<?php
}
}
?>
<p> <a href="index_admin.php" style="float:right; background-color:#CCCCCC">back admin panel</a></p>
</div>
</div>