Click on one of the products below to get a full specification.
$availability = "%P%";
#Connect and select database
$mysql_link = mysql_connect("localhost", "chemusa", "Chem586");
mysql_select_db("chemusa", $mysql_link);
#Get the number of rows
$query = "SELECT * FROM chembooks WHERE availability LIKE '$availability' ORDER BY Model ASC";
$result = mysql_query($query, $mysql_link);
$numrows = mysql_num_rows($result);
for($a = 0; $a <= $numrows; $a++) {
$id = mysql_fetch_row($result);
$pids[$a] = $id[0];
}
for($b = 0; $b <= $numrows; $b++) {
$product_id = $pids[$b];
include("chem_model_distinct.php3");
print "\n";
if($product_id != "") {
print "| ";
print "$Tradename $Model";
print " | \n";
}
$product_id = $pids[++$b];
include("chem_model_distinct.php3");
if($product_id != "") {
print "";
print "$Tradename $Model";
print " | \n";
}
print " ";
$product_id = $pids[--$b];
include("chem_model_distinct.php3");
print "\n";
if($product_id != "") {
print "| $Web_Text1 | \n";
}
$product_id = $pids[++$b];
include("chem_model_distinct.php3");
if($product_id != "") {
print "$Web_Text1 | \n";
}
print " ";
}
?>
Products
Catalog | Individual Specifications
| Specification Summary For All | Product
History
What The Media Says About
ChemBooks
|