|
include ('../includes/icon_table.inc');
?>
|
|
include ('../includes/section_navigation.inc');
if (isset($p)) {
$sql=("SELECT N.StoryID, N.StoryTitle, N.StoryText, NI.IssueDate FROM SINewsletter AS N, SINewsletterIssues AS NI WHERE N.IssueID=NI.IssueID AND N.StoryID=$p AND N.ActiveFlag=1 LIMIT 1");
if ((isset($debug)) && ($debug == 1)) print " $sql \n";
$query=mysql_query($sql);
if($result=mysql_fetch_array($query)){
$StoryID=$result["StoryID"];
$StoryTitle=GrabHTML($result["StoryTitle"]);
$IssueDate=date('M d, Y', mysql_to_epoch($result["IssueDate"]));
$StoryText=addPhotos(GrabHTML($result["StoryText"]),$StoryID,$SectionID);
print "\n";
print "\n";
print "$IssueDate \n";
print "\n";
print " | \n";
print "\n";
print "\n";
print "\n";
print " | \n";
// search form
print "\n";
print " \n";
print " \n";
print " | \n";
print " \n";
print " | \n";
print "\n";
print "\n";
print $StoryText . " ";
print " | \n";
print " \n";
}
} else {
$sql=("SELECT TextID, Title, Text FROM SIFormText WHERE SectionID=$SectionID AND TextTypeID=$type AND ActiveFlag=1 ORDER BY SortOrder ASC LIMIT 1");
if ((isset($debug)) && ($debug == 1)) print " $sql \n";
$query=mysql_query($sql);
if($result=mysql_fetch_array($query)){
$TextID=GrabHTML($result["TextID"]);
$Title=GrabHTML($result["Title"]);
$Text=addPhotos(GrabHTML($result["Text"]),$TextID,$SectionID);
print "\n";
print "\n";
print "\n";
print " | \n";
print "\n";
print "\n";
print "\n";
print " | \n";
// search form
print "\n";
print " \n";
print " \n";
print " | \n";
print " \n";
print " | \n";
print "\n";
print "\n";
print $Text . " ";
print " | \n";
print " \n";
}
}
print " | \n";
$sql_titles = ("SELECT N.StoryID, N.StoryTitle, NI.IssueDate FROM SINewsletter AS N, SINewsletterIssues AS NI WHERE N.IssueID=NI.IssueID AND NI.ActiveFlag=1 AND N.ActiveFlag=1 ORDER BY NI.IssueDate DESC");
$query_titles = mysql_query($sql_titles);
if ($result_titles = mysql_fetch_array($query_titles)) {
$first_loop = 1;
print "\n";
print "\n";
print "\n";
do {
print "\n";
print "" . date('M d, Y', mysql_to_epoch($result_titles["IssueDate"])). " | ";
print " > | ";
print "" . GrabHTML($result_titles["StoryTitle"]) . " | ";
print " \n\n";
} while ($result_titles = mysql_fetch_array($query_titles));
print " \n\n";
print " | \n";
print " \n";
}
?>
|
Attention Handheld Users
Palm and Windows CE users can subscribe to this page by clicking the link below. As a subscriber, you'll be in touch with the latest news and events concerning Scully Interactive as it happens right from the palm of your hand. An AvantGo account is required.
include ('../includes/news_subscribe.inc');
?>
|
|
include ('../includes/side_links.inc');
?>
|
|