### 3/3/01 ###### Most of this page has been left as non PHP where possible to allow ###### editing by a simple html editor. ###### Change for each form: Must be the name of the table each form accesses. $table="bibliography"; ###Links in the mysql connection information. include ("MySQLinfo.phpi"); ######## Connects to database ######## $mysql_link=MYSQL_CONNECT(HOSTNAME,USERNAME,PASSWORD); mysql_select_db(DBNAME, $mysql_link); ### CONNECTING TO THE DATABASE $search="select max(year) from $table"; $result=MYSQL_QUERY($search, $mysql_link); $end_year = mysql_result ( $result, 0, 'max(year)' ); #$search="select min(year) from $table WHERE year!=''"; $search="select min(year) from $table"; $result=MYSQL_QUERY($search, $mysql_link); $start_year = mysql_result ( $result, 0, 'min(year)' ); $search="select distinct year from $table ORDER BY year"; $distresult=MYSQL_QUERY($search, $mysql_link); #$search="select distinct volume, issue from $table ORDER BY volume, issue"; #$volresult=MYSQL_QUERY($search, $mysql_link); #$volissnums = MYSQL_NUM_ROWS($volresult); ####SPECIFIC TO BIBLio DATABASE $search="select distinct referencetype from $table WHERE referencetype!='' ORDER BY referencetype"; $typevals=MYSQL_QUERY($search, $mysql_link); #$typevals = MYSQL_NUM_ROWS($volresult); ####SPECIFIC TO BIBLio DATABASE $search="select distinct classification from $table WHERE classification!='' ORDER BY classification"; $typevals2=MYSQL_QUERY($search, $mysql_link); $search="select COUNT(*) from $table"; $result=MYSQL_QUERY($search, $mysql_link); $numrec = mysql_result ( $result, 0, 'COUNT(*)' ); ?>

Search the CCCC ( Records)


Narrow your search:

Author Title Classification Journal
Abstract Record Number Publisher Key Terms


Search for text:
Boolean mode: Order results by:

Limit search by: Search after
and including:
Search before
and including:
Year "); FOR ($x=0;$x"); PRINT $xyear; PRINT (""); } #FOR ($x=$start_year;$x<=$end_year;$x++) #{ # PRINT (""); #} PRINT (""); ?> "); FOR ($x=0;$x"); } ELSE { PRINT ("\">"); } PRINT $xyear; PRINT (""); } #FOR ($x=$start_year;$x<=$end_year;$x++) #{ # PRINT (""); #} PRINT (""); ?>
Type: "); PRINT (""); FOR ($x=0;$x"); PRINT $type; PRINT (""); } PRINT (""); ?>
Classification:
"); PRINT (""); FOR ($x=0;$x"); PRINT $classification; PRINT (""); } PRINT (""); ?>