Documentation for NLS Bibliography Maintenance Functions on bogrex

NLS Bibliography - Reports Documentation

Process / program name

Public Access / subtext.php3

Description

This program creates a temporary table and inserts the id numbers of the abstracts that match the input string into the temporary table. Then it inserts the id numbers of the descriptors that match the input string. Finaly, it inserts the id numbers of the articles' titles that contain matches to the input string.

Files called / (used) by the program

Name What it does Files called

top.php3 Adds a header to the page.

../nls-info/bls_style/nls-template-top.html Adds an NLS/BLS header to the page.

bottom.html Adds a footer to the page.

../nls-info/bls_style/nls-template-bottom.html Adds an NLS/BLS header to the page.

getcit.php3

Name	What it does	Files called
top.php3	Adds a header to the page.
../nls-info/bls_style/nls-template-top.html	Adds an NLS/BLS header to the page.
bottom.html	Adds a footer to the page.
../nls-info/bls_style/nls-template-bottom.html	Adds an NLS/BLS header to the page.
getcit.php3

mySQL Statement(s)

$asqltext = "create table text_temp select distinct id_number from ABSTRACTS where (lower(ABSTRACTS.abstract) like '%$tok%'";

$dsqltext = "insert into text_temp select distinct id_number from DESCRIPTORS,DESCRIPTOR_LIST where (lower(DESCRIPTOR_LIST.desc_text) like '%$tok%'";

$tsqltext = "insert into text_temp select distinct id_number from ARTICLES where (lower(ARTICLES.title) like '%$tok%'";

mysql_query("select distinct text_temp.id_number from text_temp,ARTICLES where text_temp.id_number = ARTICLES.id_number order by SORT_ORDER");

$result = mysql_query("drop table text_temp");

Javascript

require('../nls-info/bls_style/nls-template-top.html');
require('top.php3');
require('../nls-info/bls_style/nls-template-bottom.html');
FORM ACTION="*.php3"
require('getcit.php3');
require('bottom.php3');

manuals/system/bib-maint/reports/r-subtext.php3