" != ''){
$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 = 'product946.html';
$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('
All That Glitters - Projects Featuring the Technique of Goldwork and Stumpwork
$30.00
BKNW9203
( by Alison Cole )
While the primary focus is on Goldwork the projects include the dimensional aspect of Stumpwork. There are sections on basic suppies, stitches and techniques. The projects all have easy to read instructions, illustrations and color photographs.
Paper, 8 1/4 x 11 3/4, 136p
');
}
}
}
?>
