I'm trying to make a dropdown script to work and I'm stuck to a point where I feel the answer is simple ,but I simply can't see it .
The script should display data from the MySQL Database when I choose the last option but I don't know how to do it correctly, if someone wants to help me I would be grateful.
what i have :
MySQL Database :
category_1 --cat_id --category subcategory --subcat_id --cat_id --subcategory subcategory2 --subcat_id --subcat2 rezultate --subcat_id --articol --linieprodus --tensiune --acumulator --curentelectric
db.inc (for connection to database )
index.php ( code on pastebin.com )
The result with what I have...
When i choose the last option from the dropdown is showing only correctly " subcat2" from database .
What I want to do and I'm stuck
When i choose the last option from the dropdown I want to show a table on the same page with :
--articol ( link to an article ) | --linieprodus | --tensiune | --acumulator |
from the database "rezultate"
How do I make the connection between " rezultate " , "subcategory2" and "index.php" to show the results that I choose from the last option from dropdown ?
If it is a easy way of doing this without my messy code , I'm open for suggestions
Hope I explained good what I'm trying to do , thanks in advance for answers.
English is not my native language , so please excuse my spelling mistakes.