'."\n"; // output the current entries while($row = DB_fetch_array($result)) { $the_id = $row['id']; $timestamp = $row["timestamp"]; $the_day = date('j', $timestamp); $the_month = date('n', $timestamp); $the_date = date('j/n/Y', $timestamp); $the_year = date('Y', $timestamp); $the_category = $row['category']; $the_locked = $row['locked']; $the_tags = $row['post_tags']; $the_author_uid = $row['author_uid']; $comment_count = $row["comments"]; if($the_id < 100) { $three_int_id = '0'.$the_id; } else { $three_int_id = $the_id; } if ($comment_count == "0") { $comment_count2 = "No"; } // parse out the category id into its string value $result2 = DB_query("select * from $tblCategories where id = '$the_category'",$db) or die("

Could not select category

"); while($row2 = DB_fetch_array($result2)) { $the_category_name = $row2["category"]; } // testing // echo '
THE CATEGORY: $the_category
"); // echo '
THE CATEGORY NAME: $the_category_name
"); $the_showpref = $row["showpref"]; // Code added by JBE 11/10/2004 //********************************* $the_title = $row["title"]; if (empty($row["title"])) { $the_title = "None"; } else { $the_title = $row["title"]; } //********************************* $the_body = stripslashes($row["body"]); $title_anchor = 'post_'.$timestamp.'_'.$the_id; // parse out the category id into its string value // Parse out the autohr's full name from username in DB // $result_author = DB_query("select fullname , email, www, login from $tblUsers where id = '$the_author_uid'",$db) or die("

Could not select category

"); while($row3 = DB_fetch_array($result_author)) { $author_full_name = $row3["fullname"]; $author_email = $row3["email"]; $author_www = $row3["www"]; $author_login = $row3["login"]; } // post markup // // post header, with title and date echo ''."\n"; echo '
'."\n"; echo '

' . $the_title . '

'."\n"; echo '
'."\n"; echo ''; echo '
'."\n"; // echo '
'."\n"; // imgdate($timestamp,'/brightsky/css/elem/'); // echo '
'."\n"; // '. $three_int_id .' ' echo $the_body . "\n"; // echoes a self-contained div, #post-tags // showTags($the_tags, 'http://www.technorati.com/tags/', 'Folksonomica:', 'post-tags'); // post footer, with comment link, etc // echo ''."\n"; // the admin stuff // adminDrop($the_id); echo '
'."\n"; // closes subcontent echo ''."\n"; } echo ''."\n"; ?>