NerdConcepts Posted March 7, 2007 Share Posted March 7, 2007 Ok here is my situation. I've got 3 mysql tables that will eventually be linked together. vendors, vendor_maincat, and vendor_subcat. 'vendors' is where all the vendor (business) information is being stored. I already have a page for them to fill in their info and what category and sub-category they wish to be in. Also, within the vendors table in mysql it stores both the maincat_id and subcat_id. This is so they can be displayed during a main category search and subcategory search. All that stuff works perfectly. All I am trying to do now is make a vendor_search page by category. Basically the user will select a category. When they do it will display a drop down menu at the upper right of the page display sub-categories, and the page itself will show all the businesses within that category. If they choose a sub-category it will then only display the businesses within that sub-category. Right now all I can get it to do is either display main or subcategories. I have no idea how I can do all of this in one page. I was thinking about making a submit form that will take down the persons select category (and optional sub-category) plus their zip code (which I will already have the users default zip code when they register and login...) or they can type it in. Then when they submit the form it will display the businesses that fit their search. I have no idea which way to take this....I have it where pagination works and everything, but I am stripping the pagination off of it because I would rather the user be able to view all the businesses' name(s) and description(s) on one page (well those that fit in their category search). I also have been looking into ajax to do stuff like this but at this point I do not have the time to learn ajax to get it to work. Sorry to the long explanation, just want to make sure you get what I am saying, even though I think I may have overly complicated what I am trying to do. I seem to be doing that lately, but thanks to everyone here, it ends up working the way I need it to and a lot easier then I was making it. Link to comment https://forums.phpfreaks.com/topic/41545-difficult-to-get-my-barings-straight/ Share on other sites More sharing options...
Barand Posted March 7, 2007 Share Posted March 7, 2007 I would suggest AJAX in the instance. Does the AJAX link in my sig help to clarify it for you? Link to comment https://forums.phpfreaks.com/topic/41545-difficult-to-get-my-barings-straight/#findComment-201332 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.