end_here;
$last_category = "";
$query = "SELECT pdf.name, pdf.title, pdf.description, pdf.filesize, DATE_FORMAT(pdf.dateadded, '%m/%d/%y'), pdf_category.name, pdf_category.description from pdf, pdf_category where pdf_category.myid = pdf.category and pdf.myid > '47' order by pdf_category.myid ";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($line = mysql_fetch_array($result, MYSQL_NUM)) {
if ($line[5] != $last_category){
$content = $content . <<
$line[6]
| Name |
Description |
Size |
Date |
end_here;
}
$number = (mt_rand (25, 195)) * 1000;
$try = time - $number;
$sranddate = date("n/d/y",$try);
if ($line[4] == "00/00/00") {$line[4] = " ";}
$content = $content . << $line[1] | $line[2] | $line[3] | $line[4] |
end_here;
$last_category = $line[5];
}
$content = $content . <<
end_here;
require_once("../myclass.php");
$acategory = "PDF Listing";
$page = new HTMLTemplate();
$page->IdentifyTemplate("../template/main_full.inc");
$page->SetParameter("pagetitle", "cryan.com");
$page->SetParameter("description","Assorted PDF Documents.");
$page->SetParameter("acategory", $acategory);
$page->SetParameter("content", $content);
$page->SetParameter("date", $displaydate);
$page->CreatePage();
// require '/home/cryan/public_html/template/main.php';
?>
|
