View file dotwidgeta/showcatpicks.php

<?php


include("./admin/dotwidgeta_config.php"); 


include("./admin/connect_db.php"); 


$metatitle = $sitename . " - Category Picked";


include($file_path.$header_file);


include($file_path."includes/nav.inc"); 





$selectl = "SELECT DISTINCT articles.id as articleid, title, CID, JID, articles.description as descr"; 


$froml =   " FROM articles, article_lookup, article_cats";


$wherel =  " WHERE articles.id = JID AND CID = '$thiscat'";





$articles = mysql_query($selectl . $froml . $wherel);


if (!$articles) {


  echo("<P>Error retrieving categories from lookup table!<BR>".


	   "Error: " . mysql_error());


  exit();


}





// grab category name


$selectc = "SELECT name "; 


$fromc =   " FROM article_cats";


$wherec =  " WHERE id = '$thiscat'";





$categories = mysql_query($selectc . $fromc . $wherec);


if (!$categories) {


  echo("<P>Error retrieving categories from categories table!<BR>".


	   "Error: " . mysql_error());


  exit();


}





 while ($category = mysql_fetch_array($categories)) {


   $cat_name  = $category["name"];


//  echo("<p><b><a href=\"showarticle.php?id=".$articleid."\">$title</a></b><br>$descr ");  


 }





echo("Category: <b>" . $cat_name . "</b>"); 





while ($article = mysql_fetch_array($articles)) {


  $jid  = $article["JID"];


  $title = $article["title"];


  $articleid = $article["articleid"];


  $cid = $article["CID"];


  $descr = $article["descr"];


  echo("<p><b><a href=\"showarticle.php?id=".$articleid."\">$title</a></b><br>$descr ");  


}





include($file_path.$footer_file);





?>