";
$Item_array = mysql_fetch_array($Select_result);
$Title = $Item_array["Title"];
$Author = $Item_array["Author"];
$Abstract = $Item_array["Abstract"];
$User = $Item_array["User"];
$FileName = $Item_array["FileName"];
$LinkName = $Item_array["LinkName"];
$DateAdded = $Item_array["DateAdded"];
echo"$count. $Title
";
echo"Author: $Author
";
echo"Abstract: $Abstract
";
echo"$DateAdded
";
if ($FileName == '')
{
echo"Full Text (Web Link)";
}
else
{
echo"Full Text";
}
echo"";
}
echo"
";
echo"Total public items : $count
";
}
else
{
$Select_query = "select * from Library order by SubjectAreaName";
$Select_Result = mysql_db_query($database_name,$Select_query);
if ($Select_Result <=0)
{
echo"The Library table is missing, check if this table still exist";
exit;
}
$Num_Subject_Areas= mysql_num_rows($Select_Result); //returns the number of Subject Areas in the table
if ( $Num_Subject_Areas <= 0)
{
echo"There are currently no Subject Areas in the Library";
}
echo"
";
echo"Enter a keyword to search the library or browse from the list below
";
echo"
";
echo"";
for ( $i=0; $i < $Num_Subject_Areas; $i++)
{
$Subject_Area_Array = mysql_fetch_array($Select_Result);
$Subject_Area_Name = $Subject_Area_Array["SubjectAreaName"];
$Date_Updated = $Subject_Area_Array["DateModified"];
echo"";
echo"|
$Subject_Area_Name | ";
echo"Update: $Date_Updated | ";
echo" ";
}
echo" ";
}
}
function check_table($Db_result, $tablename)
{
if ( $Db_result <=0)
{
echo"$tablename table is missing or altered";
exit;
}
}
function check_created_table($Db_result, $tablename)
{
if ( $Db_result <=0)
{
echo"$tablename table could not be created";
exit;
}
}
function check_numrows($num_rows,$Statement)
{
if ( $num_rows <= 0)
{
echo"$Statement";
exit;
}
}
ViewLibrary();
?> |