// includes
include("./conf/conf.php");
include("./conf/functions.php");
// open database connection
$link = mysql_connect($db_host, $db_user, $db_pass) or die ("Unable to connect!");
// select database
mysql_select_db($db_name) or die ("Unable to select database!");
// generate and execute query
$id = mysql_escape_string($_GET['id']);
$query = "SELECT title, content, place, date, link, pdf FROM news WHERE new_id = '$id'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// get resultset as object
$row = mysql_fetch_object($result);
// print details
if ($row)
{
?>
echo $row->title; ?> |
$show = $row->pdf;
if($show == "0"){
}
else{?>
} ?> |
echo formatDate($row->date); ?>, echo $row->place; ?> |
echo nl2br($row->content); ?>
echo $row->link; ?> |
}
else
{
?>
That press release could not be located in our database.
}
// close database connection
mysql_close($link);
?>
|