Hi, just got intro to the list and i hope I can find some help here.
I'm trying to figure out the true syntax of a project im working on, basicly theirs a menu on my site that has several catagoies and in those catagories are secondary, and some times 3rd level and 4th level sub lists, i want to do a on click open up and ive got a good script for on click fold out lists but its the SQL syntax loops im not sure how to configure so im trying to figure out at this point how to make a nested list of the items. Then I'll worry about colasping them.
heres the psudo code im useing as my guide for my layout
Quote ------------------------------------------------------------------------ ADMIN SIDE
Category Tool
We would need to set a order of display for the category, and where its bound, (main catagoies would be bound to Main Menu, while subs would be bound to their master).
Code wise we need something like
“if Master = ‘Main Menu’ display these entries order by ‘Order of display’” for the main link and then to show the sub links we would need a nested loop to the effect
recursive “if master = Thisentry[x] display these entries order by ‘Order of display’”
1. Beauty and Health 1.1. Cosmetics 1.2. Diet & Nutrition 1.3. Fashion 1.4. Fitness 2. Computer/Electronics 2.1. Software 2.2. Hardware 2.3. Internet 2.4. Photography 2.5. Wireless 2.6. Audio 2.7. Video 3. Home and Child Care 3.1. Art and Decoration 3.2. Career/Work 3.3. Eating And Dinning 3.4. Education 3.5. Gifts 3.6. Household 3.6.1. Bedding 3.6.2. Flooring 3.6.3. Furniture 3.6.4. Houseware/Appliances 3.6.5. Gaardening 3.6.6. Tools 3.7. Pet 3.8. Staffing Services 4. On The Go 4.1. Autos 4.2. Planes 4.3. Travel & Getaways 4.4. Yacts 5. Recreation 5.1. Movies 5.2. Music 5.3. TV 5.4. Radio 5.5. Reading 5.6. Games 6. Services 6.1. Business 6.2. Charities 6.3. Finance 6.4. Insurance 6.5. Legal 6.6. Medical 6.7. Real Estate 7. Shopping (Today’s Special and Hot Stuff sub areas) 7.1. Home 7.2. Apparel and Accessories 7.3. Beauty and Health 7.4. Books, Movies & Music 7.5. Computing and Office 7.6. Gifts, Flowers & Gourmet 7.7. Jewelry & Watches 7.8. Sports & Outdoors 7.9. Toys, Kids & Baby 7.10. A-Z Store Directory 8. Sports 8.1. Clothing and Gear 8.2. Equipment 9. On The Runway ------------------------------------------------------------------------
this is pre-coding im basicly working on my "design documentation" i know what i want in psudo-code and am trying to figure out what i need to do in real code to get there.
Basicly i know how i need to set up the DB but am unsure on just how precisly to properly display that data in a format similar to the one above where's some titles are sub section of a link or sub sections of a sub section something to the effect of
code: ------------------------------------------------------------------------
Link1 -->Sublink1 -->Sublink2 -->Sublink3 -->Sublink4 -->-->Sub-sublink1 -->-->Sub-sublink2 -->-->Sub-sublink3 -->Sublink5 -->Sublink6 Link2 Link3 Link4 -->Sublink1 -->Sublink2
------------------------------------------------------------------------
Basicly a PHP version of http://advertisementworld.com/main-home.htm the flash link list there
im not to worried about the links folding out at this point though. I just want to find a way to get them to auto arrange in the right sequence.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
