// begin php
include 'header.php';
$storyID = $id;
// begin function lists
function get_title($contentID) {
$query = "select title from content where contentID = '$contentID'";
$select = safe_query($query);
while (list($title) = mysql_fetch_array($select)) {
echo "hiddenself: ".$title."";
}
}
function bar($width){
echo "
";
echo "
";
echo "
";
}
function return_story_cat($contentID) {
$query = "select category from content_category_x where contentID = '$contentID'";
$select = safe_query($query);
while (list($category) = mysql_fetch_array($select)) {
return_cat_title($category);
}
}
function return_cat_title($categoryID) {
$query = "select title from categories2 where categoryID = '$categoryID'";
$select = safe_query($query);
while (list($title) = mysql_fetch_array($select)) {
echo "category : ".$title."";
bar(150);
}
}
function list_categories() {
echo "Categories of content";
$query = "select categoryID, title from categories2 where status like 'live' order by sequence";
$select = safe_query($query);
while (list($id, $title) = mysql_fetch_array($select))
{
echo "".$title." ";
}
}
function return_byline($authorID) {
$query = "select authorID, byline from authors where authorID = '$authorID'";
$select = safe_query($query);
while (list($id, $byline) = mysql_fetch_array($select)) {
echo "".$byline." ";
}
}
function return_rating($rating) {
$query = "select title from ratings where ratingID = '$rating'";
$select = safe_query($query);
while (list($title) = mysql_fetch_array($select)) {
echo "rated: ".$title." ";
}
}
function return_content($contentID) {
$query = "select contentID, authorID, title, body, DATE_FORMAT(post_dt, '%m-%d-%Y'), keywords, ratingID from content where contentID = '$contentID'";
$select = safe_query($query);
while (list($contentID, $authorID, $title, $body, $post_dt, $keywords, $rating) = mysql_fetch_array($select)) {
return_story_cat($contentID, $catID);
return_cat_title($catID);
echo "
".$title."
";
return_byline($authorID);
echo "".$post_dt." ".$keywords." ";
return_rating($rating);
echo bar(300);
echo "".nl2br($body)."";
}
}
// end function list
?>
get_title($storyID); ?>