Documentation for NLS Bibliography Maintenance Functions on bogrex

NLS Bibliography - Reports Documentation

Process / program name

Mott Reports / fertility_child.php3

Description

This program produce the #1 Mott Bibliography entitled Fertility, Child Care & Child Development.

Files called / (used) by the program

Name What it does Files called

top.php3 Adds a header to the page.

bottom.html Adds a footer to the page.

mott-getcit.php3

mySQL Statement(s)

$fert_child_id_numbs = "select distinct ARTICLES.ID_NUMBER, SORT_ORDER
  from DESCRIPTORS, COHORTS, ARTICLES where
  (((COHORT='NLSY79') and ((DESC_NUMBER='22' ) or (DESC_NUMBER='77' ) or
    (DESC_NUMBER='338') or (DESC_NUMBER='340') or (DESC_NUMBER='352') or
    (DESC_NUMBER='382') or (DESC_NUMBER='385') or (DESC_NUMBER='388') or
    (DESC_NUMBER='389') or (DESC_NUMBER='390') or (DESC_NUMBER='442') or
    (DESC_NUMBER='524') or (DESC_NUMBER='723')) or
    (COHORT='CHILDREN of the NLSY79')) and
   (COHORTS.ID_NUMBER = ARTICLES.ID_NUMBER) and
   (DESCRIPTORS.ID_NUMBER = ARTICLES.ID_NUMBER) and 
   (SOURCE_TYPE = 'Journal Article' or SOURCE_TYPE = 'Report' or SOURCE_TYPE = 'Monograph or Chapter')) 
   order by SORT_ORDER";

$fert_child_id_numbs = "select distinct ARTICLES.ID_NUMBER, SORT_ORDER
  from DESCRIPTORS, COHORTS, ARTICLES where
  (((COHORT='NLSY79') and ((DESC_NUMBER='22' ) or (DESC_NUMBER='77' ) or
    (DESC_NUMBER='338') or (DESC_NUMBER='340') or (DESC_NUMBER='352') or
    (DESC_NUMBER='382') or (DESC_NUMBER='385') or (DESC_NUMBER='388') or
    (DESC_NUMBER='389') or (DESC_NUMBER='390') or (DESC_NUMBER='442') or
    (DESC_NUMBER='524') or (DESC_NUMBER='723')) or
    (COHORT='CHILDREN of the NLSY79')) and
   (COHORTS.ID_NUMBER = ARTICLES.ID_NUMBER) and
   (DESCRIPTORS.ID_NUMBER = ARTICLES.ID_NUMBER) and 
   (SOURCE_TYPE = 'Ph.D. Dissertation' or SOURCE_TYPE = 'Master\'s Thesis'))
   order by SORT_ORDER";

$fert_child_id_numbs = "select distinct ARTICLES.ID_NUMBER, SORT_ORDER
  from DESCRIPTORS, COHORTS, ARTICLES where
  (((COHORT='NLSY79') and ((DESC_NUMBER='22' ) or (DESC_NUMBER='77' ) or
    (DESC_NUMBER='338') or (DESC_NUMBER='340') or (DESC_NUMBER='352') or
    (DESC_NUMBER='382') or (DESC_NUMBER='385') or (DESC_NUMBER='388') or
    (DESC_NUMBER='389') or (DESC_NUMBER='390') or (DESC_NUMBER='442') or
    (DESC_NUMBER='524') or (DESC_NUMBER='723')) or
    (COHORT='CHILDREN of the NLSY79')) and
   (COHORTS.ID_NUMBER = ARTICLES.ID_NUMBER) and
   (DESCRIPTORS.ID_NUMBER = ARTICLES.ID_NUMBER) and 
   (SOURCE_TYPE = 'Oral Presentation\, Conference' or SOURCE_TYPE = 'Working Paper' or SOURCE_TYPE = 'In\-progress Research'))
   order by SORT_ORDER";

Javascript

require('top.html');
require('bottom.html');
FORM ACTION=\" *.php3\"

bib-maint/documentation/d-fertility_child.php3

Name	What it does	Files called
top.php3	Adds a header to the page.
bottom.html	Adds a footer to the page.
mott-getcit.php3