vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   advice if you may: db tables (https://vborg.vbsupport.ru/showthread.php?t=92265)

sabret00the 07-15-2005 03:17 PM

advice if you may: db tables
 
ok i have a table called sections, another called categories and i need another called style.

section is the master table, their are something like 17 categories, 14 belonging to sectionid1 and the others to sectionid2.

now i have style which is a child of categories and for all but row that link to sectionid2, theirs a mere two options for style. but for those three children of sectionid2 theirs like 10 each.

now here's where it helps to understand the implementation, i have a form and i click the section and the relevant catergory appears and you click the cat and the relevant style appears, this is done with dhtml. (all in theory so far).

given that implemation what's the best way to store the styles? i was thinking of just making a table with styleid, stylename, catid, description.

however to make the dropdowns without going nuts on the queries am i going about it the best way?


All times are GMT. The time now is 05:11 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02643 seconds
  • Memory Usage 1,697KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete