I am using the following approach, the subcategories are parented to each category's index number:
Code: Select all
<?php
//connect to DB
require_once('database-connect.php');
$cat_query = "SELECT * FROM categories ORDER BY category_index ASC";
$cat_result = mysql_query($cat_query) or die('Error in Query: ' . mysql_error());
//create a combobox
echo '<select name="select" id="select">';
while($row = mysql_fetch_array($cat_result)){
$category_index=$row['category_index'];
$category_title=$row['category_title'];
echo '<option value="'.$category_index.'">'.$category_title.'</option>';
//SUBCATEGORIES
$subcat_query = "SELECT * FROM subcategories WHERE subcategory_parent='$category_index' ORDER BY subcategory_index ASC";
$subcat_result = mysql_query($subcat_query) or die('Error in Query: ' . mysql_error());
while($row = mysql_fetch_array($subcat_result))
{
$subcategory_index=$row['subcategory_index'];
$subcategory_title=$row['subcategory_title'];
echo '<option value="'.$subcategory_index.'">--'.$subcategory_title.'</option>';
}
//END OF SUBCATEGORIES
}
echo '</select>';
mysql_close();
?>