Control to display categories and subcategories Programming Web Development by greeny_1984 …containing categories and subcategories. Iam using datalist to display categories. I want ot get subcategories based on categories …selected. On clicking on again subcategories i need to display …product page. a category can have any no of subcategories in it. I want to display all this … Getting products details from categories / subcategories with AJAX call Programming Web Development by jkon … an example of getting products details from categories – subcategories using ajax call. I am fond of OOP and… categories of them. The categories can have either subcategories or are a category that has products. We …`TYPE` smallint(1) NOT NULL COMMENT '0 Category with subcategories | 1 Category with products', `TITLE` varchar(255) CHARACTER … show all items under subcategories Programming Web Development by OsaMasw … working on php script I noticed that categories and subcategories works seperatly if I clicked on main category its…all articles under this main category and nothing imported from subcategories, now am working on somthing like this, so … my SQL command. for example Category with id = 1 has subcategories with parent_id = 1 thier ids are : 15 - 20 -… Categories and subcategories Programming Web Development by GlenRogers …, some of these categories have subcategories and some don't. Categories and subcategories are kept in mysql tables. … category table. And I have code to add subcategories to the subccategory table that takes the id value… that category are displayed. And for categories with subcategories the products for each subcategory are displayed when the… Re: Categories and subcategories Programming Web Development by GlenRogers … } ).show(); } And the menu with the categories and subcategories <?php include 'connect.php'; $q = "SELECT … sublist FROM categories AS c LEFT JOIN subcategories AS s ON c.cat_id = s.…: cat_id - int(10) ai category - varchar(100) subcategories: subcat_id - int(10) ai subcategory - varchar(100) cat_id… how to create database for business site containing no of subcategories Programming Databases by greeny_1984 … to that we want to create a website containing categories,subcategories. the problem is that we dont no exactly how many… no of subcategories will be present. I want dynamically create subcategories.Can any PLZ give me the… Re: how to create database for business site containing no of subcategories Programming Databases by tesuji …completely independently from the number of categories and subcategories are (recursive) trees in SQL. There … and the table now has over 4000 categories and subcategories, still increasing. [code=SQL] create table categories …6,8,'LCD'); commit -- for example select all subcategories of category hardware select * from categories where ucat =… How to show Categories followed by their subcategories in dropdown? Programming Web Development by chintan@dani … printing 'ul' if we don't have subcategories for this category global $menu_array; //use global…); //call function again to generate nested list for subcategories belonging to this category } } if ($has_childs ===… Re: Categories and subcategories Programming Web Development by GlenRogers … categories table and some will have the id from the subcategories table. both tables might have rows with the same id… be even numbers and ai by 2 and id in subcategories be odd number and ai by 2. Then I could… Re: Categories and subcategories Programming Web Development by GlenRogers … more thing on this? When I click on a categories subcategories, it shows me the products that are in one subcategory…(s.subcategory) AS sublist FROM categories AS c LEFT JOIN subcategories AS s ON c.cat_id = s.cat_id GROUP BY c… Re: Populating required number of categories, duplicating the subcategories. Programming Web Development by kantigniter … /*echo "<pre>"; print_r($data['subCategories']); exit;*/ $data['body_content'] = 'think/visualize'; $data…;QuestionAnswerOuter"> <?php if($subCategories) foreach($subCategories as $subCategory){ $subSubCategories = $this-&… display category of subcategories and sub/subcategories Programming Web Development by afroo.gfx … //this prevents printing 'ul' if we don't have subcategories for this category global $menu_array; //use global array variable … generate_menu($key); //call function again to generate nested list for subcategories belonging to this category echo '</li>'; } } … Re: Categories and subcategories Programming Web Development by pixelsoul … code. If you are trying attribute products to categories and subcategories, then the products table should have two columns, one for… Re: Categories and subcategories Programming Web Development by GlenRogers …. If a product is added to a category with no subcategories the subcat_id field gets a NULL value. Should I be… Re: Categories and subcategories Programming Web Development by GlenRogers …(s.subcategory) AS sublist FROM categories AS c LEFT JOIN subcategories AS s ON c.cat_id = s.cat_id GROUP BY c… Re: Categories and subcategories Programming Web Development by GlenRogers … way it was (ajax included again) and forgetting about the subcategories for now This works, the data for product_name and product_price… Re: Categories and subcategories Programming Web Development by GlenRogers …,'|', s.subcategory ) AS sublist FROM categories AS c LEFT JOIN subcategories AS s ON c.cat_id = s.cat_id"; if(isset… Re: how to create database for business site containing no of subcategories Programming Databases by tesuji … great, and the table now has over 4000 categories and subcategories, still increasing... tesu[/QUOTE] We don't have 4000, sorry… Re: need help: list articles by multi categories and subcategories Programming Web Development by diafol … this info... This is a possible schema... categories: cat_id | cat_name subcategories: subcat_id | subcat_name | cat_id article: art_id | title | description | ... | subcat_id SELECT a….* FROM articles AS a INNER JOIN subcategories AS s ON a.subcat_id = s.subcat_id INNER JOIN categories… Need help with DB Schema - Post with multiple Categories and SubCategories Programming Databases by bprosic Hi, I want to design DB for posts with multiple subcategories and categories. Example: Category has information: C#, PHP, JS, Python. … it all because I'm missing something. I could delete subcategories and stick to only categories and use tags? That is… Re: Need help with DB Schema - Post with multiple Categories and SubCategories Programming Databases by bprosic I think that I will delete a foreign key in subcategories table and foreign keys in posts table. Then I will create another table postCatSubCatMap which will combine posts, categories, subcategories with foreign keys. Re: need help: list articles by multi categories and subcategories Programming Web Development by jkon … to get all the posts of a gatecory and its subcategories // ordered by CREATION_TIMESTAMP DESC // Here we get the category id… we want and its subcategories ids in a comma seperated String // in this example with… A database with categories and subcategories Programming Databases by yazer … categories off into another table .. now I need to add subcategories ... I read a bit .. and found someone doing this : [CODE… Report w/Cateories/subcategories Programming Web Development by tlei … the data into an html table but all the categories, subcategories, etc get repeated for every record, like this: [code] Category1… php and subcategories Programming Web Development by OsaMasw … there I managed somehow to create and call categories and subcategories in DB my problem now how to design them as… Re: php and subcategories Programming Web Development by jkon …/web-development/php/code/437655/getting-products-details-from-categories-subcategories-with-ajax-call- . Let’s see the fundamentals of it… How to get duplicate categories, and subcategories in the page. Programming Web Development by kantigniter … many I entered. As in like the categories, and the subcategories under them. Under exterior, I have a set of categories… Re: How to get duplicate categories, and subcategories in the page. Programming Web Development by diafol … that you have a room class that spits out the subcategories for each room type (e.g. nameboard frame) and the… Populating required number of categories, duplicating the subcategories. Programming Web Development by kantigniter … form should be duplicated in the second form, and the subcategories under them, and the sub sub categories under them. This… Re: Populating required number of categories, duplicating the subcategories. Programming Web Development by kantigniter … the second form. I have other tables in for categories, subcategories, groups, and items, I'm not sure which part you…