Krest

Krest is a leading crown and bridge dental laboratory, serving the dental community since 1980. We pride ourselves on the relationships we build with our clients, viewing prosthetic dentistry as a partnership between the dentist and the laboratory. Our team of dedicated employees is committed to simplifying the process of crown and bridge and helping you deliver quality dentistry. In twenty-five years we’ve learned a few things about what dentists really want from a lab:

Knowledge
Reliability
Consistency

sql_query("SELECT * FROM categories ORDER BY position"); $cats=$db->fetched_array(); if(!isset($_GET["CID"])) $_GET["CID"] = $cats[0]["id"]; ?> sql_query("SELECT * FROM subcats WHERE cat_id=".$_GET["CID"]." ORDER BY position"); $sub=$db->fetched_array(); if(!isset($_GET["SID"])) $_GET["SID"] = $sub[0]["id"]; if($sub===false) $num2=0; else $num2=count($sub); for($j=0;$j<$num2;$j++){ if($_GET["SID"] == $sub[$j]["id"]) $style="ttyltextselect"; else $style="ttyltext"; ?> sql_query("SELECT * FROM subsubcats WHERE sub_id=".$sub[$j]["id"]." ORDER BY position"); $subsub=$db->fetched_array(); ?>

	class=>
	&SID= class= onMouseOut="deactivate();" onMouseOver="activate();">

sql_query("SELECT * FROM categories WHERE id=".$_GET["CID"]); $cat=$db->fetched_array(); $title = $cat[0]["name"]; if(isset($_REQUEST["SID"])){ $db->sql_query("SELECT * FROM subcats WHERE id=".$_GET["SID"]); $sub=$db->fetched_array(); if($sub[0]["name"] != "") $title .= "/".$sub[0]["name"]; } if(isset($_REQUEST["SSID"])){ $db->sql_query("SELECT * FROM subsubcats WHERE id=".$_GET["SSID"]); $subsub=$db->fetched_array(); if($sub[0]["name"] != "") $title .= "/".$subsub[0]["name"]; } ?>

sql_query("SELECT * FROM products WHERE subsub_id=".$_REQUEST["SSID"]); $prod=$db->fetched_array(); $text = ""; if($prod===false) $num4=0; else $num4=count($prod); for($i=0;$i<$num4;$i++){ $text .= "

".$prod[0]["description"]."

"; } } ?>