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('
Nomadic Embroideries
$49.99
BKNW9708
More than 500 images explore the free-form embroidered creations of the tribal people of Gujarat Province in India. Abstract, geometric, floral, & religious imagery celebrates the boundless exuberance of their quest for beauty. color photos throughout. 8 3/4 x 11, Hard, 208 p
');
}
}
}
?>
