Thread: PHP/MySQL query question
01-19-07, 04:14 #1Registered User
- Join Date
- Oct 2004
Unanswered: PHP/MySQL query question
I'm developing a php/mysql driven product catalog and I encountered a problem with some queries.
Here is how my structure looks like:
Family -> SubFamily -> Groups -> Products
I made a single file which handles all this, so I've done it with Posting the variables from the links to the same page in the URL. This way when I click on a family my subfamily changes, but not my group list (this changes only if I click on a subfamily so the group gets it's variable).
I have set the default $GET value for each query so when the page loads it shows 1 product from Family id1, subfamily id1, group id1.
My question is, how can I make a condition or maybe set up a session variable so when someone clicks on another FAMILY, my subfamily list automaticaly changes, and so does my group list, and so does my default product (acccording to the family,subfamily and group)?
I how someone can help me with this.
Thanks in advice.
01-19-07, 04:31 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
one is to declare the list boxes in a form and then set the onchange event handler
the other is to use AJAX and update only the aprts fo the form that have changed.