vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Query syntax (https://vborg.vbsupport.ru/showthread.php?t=179460)

IvyKeepMommy 05-16-2008 06:40 PM
Query syntax
 
I'm still learning about databases and something has come up that I need to check the average age of our membership (not an individual member's age, but the overall average) as part of registration, everyone is required to provide their year of birth... can anyone tell me what query I would use that would either just list the year of birth (not attached to names) or that could calculate the average age of the membership population?

Boofo 05-16-2008 08:00 PM
<a href="https://vborg.vbsupport.ru/showpost.php?p=596879&postcount=4" target="_blank">https://vborg.vbsupport.ru/showp...79&postcount=4</a>

IvyKeepMommy 05-16-2008 09:47 PM
Thanks Boofo! You are the best!!

Boofo 05-16-2008 10:38 PM
Awww, you're just saying that because it's true. ;)

Glad I could help. ;)


All times are GMT. The time now is 09:56 PM.

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.01128 seconds
  • Memory Usage 1,705KB
  • 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
  • (4)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