0) { $title_tag = "PlaNetwork Journal: ". stripslashes(urldecode($sec)); } else { $title_tag = "PlaNetwork Journal: Section Not Found"; } $bgmap = "Yes"; $showdate = "No"; include "header.php"; if ($sec_id > 0) { echo "
$sec

"; // the big query $sql1 = "SELECT distinct auth.name author, art.id article_id, art.article title, art.label, art.teaser, sc.section, sc.section_order FROM article art, author auth, article_section as1, article_section as2, section sc, category ct WHERE auth.id = art.user_id AND art.id = as1.article_id AND art.seq_id = 1 AND art.pagenum < 2 AND as1.section_id = $sec_id AND art.id = as2.article_id AND as2.section_id = sc.id AND as2.priority = 1 AND sc.category_id = ct.id AND ct.id = $ordercat_id ORDER BY art.cdate desc"; echo "
"; $result = mysql_query($sql1); $numArticles = 0; while ($data = @mysql_fetch_array($result)) { $author = $data["author"]; $article_id = $data["article_id"]; $title = $data["title"]; $label = $data["label"]; $teaser = $data["teaser"]; $section = $data["section"]; echo " $title
$author
"; if ($teaser) { echo " $teaser

"; } else { echo "

"; } } echo "
"; } echo " "; include "footer.php"; ob_end_flush(); ?>