Yes I should try and use more IF ELSE statements :) To be fair I didn't want to go for a premiere ticket just yet on this one, because I need to identify that it will do everything I need. This is why I opened up the forum post: http://www.webassist.com/forums/posts.php?id=38727
Because I am wondered if that block of code would work better for my website (as the mysql version in that forum post works fine with the previous website project). (as you once said why reinvent the wheel) :)
However what is essential is the code in this forum post where you helped me getting the custom search to work via mysqli and that part works fine. So I need to somehow combine the 2 approaches I guess.
Also I did notice one issue with the navigation code in this forum post. when the user clicks on the parent menu link of a submenu, it will still show the url for the first submenu option. for example, for the menu item: LIVING & DINING the first submenu option is OCCASIONAL CHAIRS
and it appears that they both share the same URL
For example the parent (which is LIVING & DINING) in theory should be http://localhost/armadillo/category.php?Department=Living-Dining&Category=
should I separate parent and child menu items in separate tables?