Category, subcategory problem

[browneyes]

Hi,

 

I'm trying to make a classified ad. I made a table for the main category and for the sub category. When the user will select from the main category, I'd like to display just those in the subcategory. I really tried but I can't solve it yet.

 

Here's the code.

 

<form name="form1" method="post" action="">
 <select name="select" size="10">
   <?php
do {  
?>
   <option value="<?php echo $row_Recordset1['mid']?>"><?php echo $row_Recordset1['mdesc']?></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>
 <select name="select2" size="10">
   <?php
do {  
?>
   <option value="<?php echo $row_Recordset2['sid']?>"><?php echo $row_Recordset2['sdesc']?></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>
</form>

 

 

Is there a better way of doing this? Any site you recommend?

 

Any info would be greatly appreciated.

 

--Browneyes

 

 

[jetsett]

Do you mean that when you select from the main catagory, only the sub categories of the selected main item are displayed. If this is what you mean then you need a multiple cascading menu that dynamically displays the sub-menus when the main value is selected.

There is a very good MX extension available from Phakt that simplifys this menu type creation called MX Widgets

Look here MX Widgets

 

Hope this helps