Documentation for NLS Bibliography Maintenance Functions on bogrex

NLS Bibliography - Maintenance Documentation


Process / program name

* / pub_upd.php3

Description

This program formats the edit form for the publisher, fills out its fields with the current data located for the publisher_id number, and displays them to the user ready for edit.

Files called / (used) by the program

NameWhat it doesFiles called
top.php3Adds a header to the page. 
bottom.htmlAdds a footer to the page. 
x_pub_update.php3Deletes old data and updates publisher record with new data. 
link_delete.php3Deletes publisher's associated journal links. 
link_update.php3Updates publisher's associated journal links. 

mySQL Statement(s)

  • mysql_query("select * from PUBLISHERS where PUBLISHER_NUMBER=$pubnum",$db);
  • mysql_query("select JOURNAL from PUBLISHER_LINK where PUBLISHER_NUMBER=$pubnum order by JOURNAL",$db);
  • bis--mysql_query("select JOURNAL from PUBLISHER_LINK where PUBLISHER_NUMBER=$pubnum order by JOURNAL",$db);
  • mysql_query("select distinct TRUNC_SOURCE from ARTICLES order by TRUNC_SOURCE",$db);

    Javascript


    require('top.html');
    require('bottom.html');
    FORM ACTION=\"x_pub_update.php3\"
    FORM ACTION=\"link_delete.php3\"
    FORM ACTION=\"link_update.php3\"


    manuals/system/bib-maint/maintenance/d-pub_upd.php3