" != ''){
$subcat_link = '';
$subcat = '';
$category = strtolower("");
$category = str_replace(' ', '_', $category);
$cat_name = ucwords(str_replace('_', ' ', $category));
$cat_link = "/catalog/".$category."_index.php";
$dbPath = '/home/hedgehogwww/catalog_data/shopsite_db';
$database = new PDO('sqlite:'.$dbPath) or die("could not connect to database");
$page = 'ACCNCLT.SHTML';
$sql = "Select ss_productsid from ss_products where ss_filename = '$page'";
$rows = $database -> query($sql);
foreach($rows as $row){
$id = $row['ss_ProductsID'];
}
$sql2 = "Select ss_parentpagesid from ss_pagelinks where ss_productsid = '$id' Limit 1";
$rows = $database -> query($sql2) or die("could not query database");
foreach($rows as $row){
$link = $row['ss_ParentPagesID'];
$sql3 = "Select ss_pagefilename, ss_linkname from ss_pages where ss_pagesid = '$link' LIMIT 1";
$filenames = $database -> query($sql3);
foreach($filenames as $filename){
echo('
Needlecase Wood & Brass - Light
$19.50
ACCNCLT
Beautifully finished hardwood barrel with a brass screw-on cap. Approximately 3 1/2" long.
');
}
}
}
?>
