", $template[$it] ) ) { echo "MozillaZine News Archives"; $replace = 1; } if (ereg( "", $template[$it] ) ) { include("./shtml/top_nav.html"); $replace = 1; } if (ereg( "", $template[$it] ) ) { include("./shtml/ad_top.html"); $replace = 1; } if (ereg( "", $template[$it] ) ) { include("./shtml/ad_bottom.html"); $replace = 1; } if ( ereg( "", $template[$it] ) ) { require "../login.php"; $table= "mozine_articles"; @mysql_pconnect( "$dbhost", "$dbuser", "$dbpass") or die( "Unable to connect to SQL server"); @mysql_select_db( "$dbname") or die( "Unable to select database"); $result = @mysql_query( "select * from $table WHERE article_active = 'active' order by article_date desc"); $rows=@mysql_num_rows($result); echo"

MozillaZine News Archives

\n"; echo"

See the MozillaZine front page for current news.

\n"; echo "
\n"; for ($i = 20; $i < $rows; $i++) { $title=mysql_result($result, $i, article_title); $id_tag = @mysql_result($result, $i, id_tag); $article_date=@mysql_result($result, $i, article_date); $article_text=@mysql_result($result, $i, article_text); $article_subgroup=@mysql_result($result, $i, article_subgroup); $date = @mysql_query( "select date_format('$article_date', '%W %M %D, %Y')"); $article_date=@mysql_result($date, 0,0); echo "
$title"; $response_result = @mysql_query( "select * from responses WHERE article_id = '$id_tag'"); $response_rows = @mysql_num_rows($response_result); if ($response_rows) { echo " ($response_rows)"; } $article_result = @mysql_query( "select * from mozine_articles WHERE id_tag ='$id_tag'"); if (@mysql_result($article_result,0, article_longtext)) { echo " \"Full"; } echo "
\n"; echo "
$article_date
\n"; } echo "
\n"; } if ($replace != 1){ echo "$template[$it]"; } else { $replace = 0; } } ?>