Forming a query string

vertmonkee

I have a drop down list with parent categories and sub categories which would look like this

Parent Category 1
Sub category 1
Sub category 2
Sub Category 3
Parent category 2
Sub category 1
Sub category 2
Parent category 3

The drop down list is part of a form. The form’s action is index.php and method is GET.

When the form is sent the query string will need to read this for a parent category

index.php?page=15&cat=value of parent category

And this for a sub category

index.php?page=15&cat=value of parent category&subcat=value of sub category.

All of the values are numeric and are stored in a databse. The drop down list is created dynamically.

My problem comes with forming the query string. I have tried different methods but none of them work.

Has anybody got ideas of how I could solve this?

Thanks for any help.

Installer

Is this what you mean?

$query = "SELECT * FROM my_table WHERE parent_cat = '" . $_GET['cat'] . "' AND sub_cat = '" . $_GET['subcat'] . "'";

vertmonkee

Thanks for the idea Installer.

Unfortunatley I was referring to query string in the url.

Thanks again.

Installer

Well, the request uri string should be automatically formed by the browser when the form is submitted.

vertmonkee

I'm starting to think about doing the whole thing another way. The parent categories and sub categories work fine for a different method of navigation.

But trying to use a drop down menu in this way is either going to be impractical or impossible.

Thanks for your time Installer, I think I'll mark this resolved.

If only there was a way to mark threads "Abandoned" . ha ha