Data base and html form issue

[powerofphp]

Hi,
I have categories in datbase table, and each categories has further subcategories these subcategories (of specific category) has different input fields , i show these if a user select a category then those specific fields from database have to be displayed on page and user has to fill those input fields and submit.
now what i want i?
i want to give option touser to select category when he/she delect category in next page input fields of first subcategory shown and there be a next button at bottom when click next this should display next subcategory fields and so on.
how this be done
plz help

[jdiver]

When the user submits the form (after selecting the first category), just do a query that would look something like:

// Run the query
$sql = "SELECT subcategory_id, subcategory_name FROM table WHERE category_id = " . $HTTP_POST_VARS['category_id'] . "";

// Get the result
$result = mysql_query($sql);

// Loop through the rows
while ($row = mysql_fetch_row($result))
{
  echo "Sub Category " . $row['subcategory_id'] . " = " . $row['subcategory_name'] . "<br />";
}

I obviously have no clue what your specific tables and fields are, but you can just replace as needed.