// begin php
include 'header.php';
// begin function lists
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 $title;
}
}
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 bar($width){
echo "
";
echo "
";
echo "
";
}
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_category($id){ // show carnal counsels latest
$query="select a.title, a.authorID, DATE_FORMAT(a.post_dt, '%m-%d-%Y'), a.ratingID, b.contentID
from content a, content_category_x b
where b.category = '$id'
and a.contentID = b.contentID
and a.status like 'live'
order by a.post_dt desc
";
$select = safe_query($query);
while (list($title, $author, $date, $rating, $id) = mysql_fetch_array($select)){
echo "".$title." ";
return_byline($author);
echo "".$date."";
$width="150";
bar($width);
}
}
// end function list
?>
hiddenself: return_cat_title($id); ?>
include 'includes/meta.html'; ?>