Unable to connect to the database server");
exit();
}
// Select the database
if (! @mysql_select_db($database) )
{
echo( "Unable to locate headlines database
");
exit();
}
$count = 0;
if (isset($_GET['story']))
{
$showfirst=$_GET['story'];
$showlast=$_GET['story'];
}
else
{
$showfirst=1;
$showlast=99999;
}
$result = mysql_query( "SELECT * FROM headlines
WHERE headline between $showfirst and $showlast
and show_as_news = 'Yes'
ORDER by headline_date desc");
if ($result)
{
// display headlines in reverse order
while ($row = mysql_fetch_array($result) )
{
//show title (as tag)
echo "";
echo "| ";
echo "" . $row["Title"] . "";
echo " | ";
echo "";
echo "Added: " . date("D F j, Y",mysqldate_to_unix_timestamp($row["headline_date"])) . " ";
echo " | ";
echo "
";
//show body
echo "| ";
if ( (ctype_space($row["Body"])) or is_null($row["Body"])) echo $row["Body"]; else echo $row["Teaser"];
echo " |
";
echo "| |
";
$count =+ 1;
}
// if none found, say so
if ($count == 0)
{
echo("| ");
echo("No news found");
echo(" |
");
}
}
else
{
echo("Error getting headlines:
" . mysql_error() . "
");
exit();
}
?>