#####Pages Created By Dan Green
### 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 PRINT
ucwords($table); ?> ( PRINT $numrec; ?> Records)
- Type in the data for which you want to search. Separate terms with white
space; enclose phrases in quotation marks. For example: "writing classroom"
"internet literacy." Searching without terms will display the
entire contents
of the database.
- To narrow your search:
- change the Boolean mode from "or" to "and";
- use more phrases rather than single terms;
- choose one or more search fields;
- limit the dates of your search by year;
- limit type of document.
- Click here for help.