|
".$row->article_title." \n";
print "".$row->article_byline." \n";
print $row->article_text;
if ($count < $num)
{
print "
\n";
}
}
if ($search_key && !$num)
{
print("The following errors were found:
");
print("- No articles were found for the given search key.");
}
*/
if ($search_key)
{
$upper_key = strtoupper($search_key);
$qry = "select article_id, article_created_date, article_title, article_byline, article_text from
article where article_live_flag=1 and ucase(article_title) like '%".$upper_key."%'
order by article_rank, article_title";
}
if (isset($article_id) || isset($hp_article_id))
{
if(!$search_key && $article_id)
{
$qry = "select article_id, article_title, article_byline, article_text, article_created_date
from article where article_live_flag=1 and article_id=".$article_id." order by article_rank, article_updated_date, article_title";
$result = dbQuery($qry);
$num = dbNumRows($result);
$count = 1;
while ($row=dbResults($result))
{ print "".$row->article_title."
\n";
print "".$row->article_byline." - ".$row->article_created_date." \n";
print $row->article_text;
print " ";
print " ";
if ($count < $num) {print "
\n";}
}
}
if(!$search_key && $hp_article_id)
{
$qry = "select hp_article_id, hp_article_text, hp_article_subtitle, hp_article_updated_date from hp_article
where hp_article_live_flag=1 and hp_article_id=".$hp_article_id;
$result = dbQuery($qry);
dbSqlError($result);
if ($row=dbResults($result))
{
//print "From the President\n";
print "".$row->hp_article_subtitle." \n";
print "Robert S. Eilert - ".$row->hp_article_updated_date." \n";
print $row->hp_article_text;
print " ";
print " ";
if ($count < $num) {print "
\n";}
}
}
}
else
{
if(!$search_key)
{
$qry = "select article_id, article_created_date, article_title, article_byline, article_blurb from
article where article_live_flag=1 order by article_rank, article_updated_date, article_title";
}
$result = dbQuery($qry);
$num = dbNumRows($result);
$count = 1;
while ($row=dbResults($result))
{ $article_id = $row->article_id;
print "".$row->article_title."\n";
print "".$row->article_byline." - ".$row->article_created_date." \n";
print $row->article_blurb;
print " ";
print "more
";
}
}
if ($search_key && !$num)
{
//print("The following errors were found:
|
