@ $db = mysql_pconnect("sql.media.mit.edu", "mf", "used2bic");
if (!$db) {
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("mf");
$query = "SELECT id, title, author, DATE_FORMAT(date, '%M'), DATE_FORMAT(date, '%Y'), description, doctype, abstract, url, researchgroup FROM pubs WHERE id = ". $id;
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
$row = mysql_fetch_row($result);
$title = htmlspecialchars( stripslashes($row[1]) );
$author = htmlspecialchars( stripslashes($row[2]) );
$month = htmlspecialchars( stripslashes($row[3]) );
$year = htmlspecialchars( stripslashes($row[4]) );
$desc = htmlspecialchars( stripslashes($row[5]) );
$doctype = htmlspecialchars( stripslashes($row[6]) );
$abstract = ($row[7]);
$url = htmlspecialchars( stripslashes($row[8]) );
$researchgroup = htmlspecialchars( stripslashes($row[9]) );
$date = $year;
if ($month) {
$date = $month . " " . $year;
}
$fixAbstract = str_replace($abstract, " ", "\n\n");
$fixAbstract = str_replace($abstract, " ", "\n");
echo " $title ";
echo " $author ";
echo " $date ";
echo " ";
echo " Abstract";
echo " ";
echo "$abstract";
echo " ";
echo " ";
echo " $desc ";
echo " ";
echo " $url ";
?>
|