Execute($articlesql); print ""; $header_image='columnheader_lastcolumn.gif'; $section_id=11; $section=11; $icon_image='icon_comics.gif'; $article_type='column'; $article_type_pic='columns.gif'; $middle="feature.html"; $section_name='comics'; $section_image='comics.gif'; $image_folder="comics/comics_features"; while (!$articlesql->EOF) { $author_name=$articlesql->fields['author_name']; $pubdate=$articlesql->fields['date']; $article_name=$articlesql->fields['article_name']; $article=$articlesql->fields['article_id']; $text=$articlesql->fields['text']; $image=$articlesql->fields['image']; $author_email=$articlesql->fields['author_email']; $articlesql->MoveNext(); } $featured_features= "Select article_id, name, author_name from articles where article_type='feature' and section_id=$section_id and current=1 order by pubdate DESC limit 3"; $features=0; $featured_features = $Link->Execute($featured_features); while (!$featured_features->EOF) { $features=$features+1; $feature_article_id[$features]=$featured_features->fields['article_id']; $name[$features]=$featured_features->fields['name']; $feature_author_name[$features]=$featured_features->fields['author_name']; $featured_features->MoveNext();} if (($section_id)==11) { if (($article_type)=='review') { $middle="comic_main_review.html"; $image_folder="comics/comics_reviews";} if (($article_type)=='feature') { $middle="feature.html"; $image_folder="comics/comics_features";} $featured_reviews= "Select article_id, comic_name, comic_publisher, author_name from articles where article_type='review' and section_id=$section_id and current=1 order by pubdate DESC limit 8"; $reviews=0; $featured_reviews = $Link->Execute($featured_reviews); while (!$featured_reviews->EOF) { $reviews=$reviews+1; $review_article_id[$reviews]=$featured_reviews->fields['article_id']; $line1[$reviews]=$featured_reviews->fields['comic_name']; $line2[$reviews]=$featured_reviews->fields['comic_publisher']; $review_author_name[$reviews]=$featured_reviews->fields['author_name']; $featured_reviews->MoveNext();} } ?>