Documentation for NLS Bibliography Maintenance Functions on bogrex

NLS Bibliography - Maintenance Documentation

Process / program name

* / xentire.php3

Description

This program deletes all traces of data in a table row of the db that are associated with the id number of the citation (existing or new). It then calls inserts the incoming data in the database row.

Files called / (used) by the program

Name What it does Files called

top.php3 Adds header to the page.

bottom.html Adds footer to the page.

../nls-bib/getcit.php3 This program displays (prints to screen) one or more records.

Name	What it does	Files called
top.php3	Adds header to the page.
bottom.html	Adds footer to the page.
../nls-bib/getcit.php3	This program displays (prints to screen) one or more records.

mySQL Statement(s)

$sqltxt = "insert into SORTED_LOOKUP values ("; for ($i=1; $i<=4; $i++) { $sqltxt = $sqltxt . "'" . $a[$i] . "',"; } $sqltxt = $sqltxt . "'" . $title . "'," . $idnum . ")";

mysql_query("insert into COHORTS values ($idnum, '$chrt[$i]')", $db);

mysql_query("insert into DESCRIPTORS values ($idnum, '$drow[0]')", $db);

mysql_query("insert into ABSTRACTS values ($idnum, $i, '$a')", $db);

mysql_query("select * from SORTED_LOOKUP order by AUTHOR1,AUTHOR2,AUTHOR3,AUTHOR4,TITLE",$db);

Javascript

require('top.html');
require('bottom.html');