Jump to content


Photo

Category, subcategory problem


  • Please log in to reply
1 reply to this topic

#1 browneyes

browneyes
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 18 June 2004 - 04:28 PM

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



#2 jetsett

jetsett
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 24 June 2004 - 08:37 PM

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 :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users