Here, you can find articles on web authoring and programming, featuring content for web designers of all levels of experience.

"; include "connect.php"; if ($first == "") // ***** MAIN INDEX ***** { $title = "WebFu Articles"; $tagline = "Web Development Articles"; include "begin.php"; echo "\n\n
"; //Main Index - List all categories $result = mysql_query("select distinct article_category from articles") or die(mysql_error()); echo "\n
\n"; echo "
"; echo "

Categories

\n"; echo " \n"; echo "
\n\n"; echo "
\n"; //Intro echo $articles_intro; //List articles in paged format $result = mysql_query("select distinct article_title, article_url, article_synopsis from articles") or die(mysql_error()); echo "\n
\n"; while($article = mysql_fetch_array($result,MYSQL_NUM)) { echo "
$article[0]
\n"; echo "
$article[2]
\n"; } echo "\n
\n"; echo "
\n\n"; } elseif ($first == "categories") // ***** SPECIFIC CATEGORY ***** { $title = "WebFu Articles - $second"; $tagline = "Web Development Articles"; include "begin.php"; echo "\n\n
"; //search db for all articles under this category $sql = "select distinct article_title, article_url from articles where article_category = '$second'"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_num_rows($result) == 0) {echo ("

No articles found under category "$second"

");} else { echo "

$second

"; //List all articles under this category echo "\n"; } } else // ***** DISPLAY ARTICLE ***** { //search for article named $first $page = 1; if (isset($second)) {$page = $second;} //check page number // select title and text from one page $sql = "select a.article_title, p.page_text, p.page_title, a.article_id, a.article_url from articles a, article_pages p where a.article_url = '$first' and p.page_num = '$page' and p.page_article_id = a.article_id "; $result = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_row($result); $art_title = $row[0]; $art_txt = $row[1]; $pg_title = $row[2]; $foreign_key = $row[3]; $art_url = $row[4]; if (mysql_num_rows($result) == 0) { $title = "WebFu"; $tagline = "Error"; include "begin.php"; echo "\n\n
\n"; echo ("

Error: Page $page of $first not found

"); } else { /* ******* DISPLAY ARTICLE ******* */ //select all page titles $sql = "select page_title, page_num from article_pages where page_article_id = '$foreign_key'"; $result = mysql_query($sql) or die(mysql_error()); $title = "$art_title - WebFu"; $tagline = "Web Development Articles"; include "begin.php"; echo "\n\n
"; echo "\n
\n"; echo "
"; echo "
$art_title
\n"; echo "
    \n"; while($pg = mysql_fetch_array($result,MYSQL_NUM)) { if ($pg[1] == $page) { echo "
  1. $pg[0]
    2. \n"; $last_page = $pg[1]; } else { echo "
  2. $pg[0]
    3. \n"; $last_page = $pg[1]; } } echo "
\n"; echo "
\n\n"; //spit out article echo "
\n"; echo "

$art_title

\n"; echo "

Page $page

\n"; echo "

$pg_title

\n"; echo $art_txt; echo "\n
\n"; //page navigation echo "\n
\n"; $prev = $page - 1; $next = $page + 1; if ($page != "1") { //Show *prev* nav echo "« PREV"; } if ($page != $last_page) { //Show *next* nav echo "NEXT »"; } echo "
\n\n"; } } echo "\n
\n"; include "end.php"; ?>