if (isset($_GET['id'])){
$q_getCategory = "SELECT product_category_$lang, product_family FROM Product WHERE product_id=\"" . $_GET['id'] . "\"";
$r_getCategory = runQuery($q_getCategory);
list($category, $family) = mysql_fetch_array($r_getCategory);
$q_getCategory = "SELECT DISTINCT(product_category_$lang) FROM Product WHERE product_family=\"$family\" ORDER BY product_category_$lang";
$r_getCategory = runQuery($q_getCategory);
?>
}
elseif (isset($_GET['category'])) {
$category = urldecode($_GET['category']);
$q_getCategory = "SELECT DISTINCT(product_category_$lang) FROM Product WHERE product_family=\"" . $_GET['family'] . "\" ORDER BY product_category_$lang";
$r_getCategory = runQuery($q_getCategory);
?>
}
elseif (isset($_GET['family'])) {
$q_getCategory = "SELECT DISTINCT(product_category_$lang) FROM Product WHERE product_family=\"" . $_GET['family'] . "\" ORDER BY product_category_$lang";
$r_getCategory = runQuery($q_getCategory);
?>
All Products
}
else {
?>
The patent of "Intelligence Illumination Thermometer" was granted by USPTO on 12/21/10.
Aviton Care has filed three patent applications on:
  - Blood pressure meter
  - Fall detection system
  - Tracking system
}
?>
if (isset($_GET['id'])) {
$q_getInfo = "SELECT product_family, product_category_$lang FROM Product WHERE product_id=\"" . $_GET['id'] . "\"";
$r_getInfo = runQuery($q_getInfo);
list ($family, $category) = mysql_fetch_array($r_getInfo);
$q_getProduct = "SELECT p.product_id, p.product_name_$lang, p.product_number, p.product_family, pi.image_filename FROM Product p, Product_image pi WHERE p.product_id=pi.product_id AND product_family=\"$family\" AND product_category_$lang=\"$category\" GROUP BY p.product_id ORDER BY product_name_$lang";
$r_getProduct = runQuery($q_getProduct);
while (list($id, $name, $number, $family, $image) = mysql_fetch_array($r_getProduct)){
?>
if ($id==$_GET['id']){
echo "";
}
?>
}
}
elseif (isset($_GET['category']) && isset($_GET['family'])){
$q_getProduct = "SELECT p.product_id, p.product_name_$lang, p.product_number, p.product_family, pi.image_filename FROM Product p, Product_image pi WHERE p.product_id=pi.product_id";
$q_getProduct .= " AND product_family=\"" . $_GET['family'] . "\"";
$q_getProduct .= " AND product_category_$lang=\"" . $_GET['category'] . "\"";
$q_getProduct .= " GROUP BY p.product_id ORDER BY product_name_$lang";
$r_getProduct = runQuery($q_getProduct);
while (list($id, $name, $number, $family, $image) = mysql_fetch_array($r_getProduct)){
?>
}
}
elseif (isset($_GET['family'])) {
$q_getProduct = "SELECT p.product_id, p.product_name_$lang, p.product_number, p.product_family, pi.image_filename FROM Product p, Product_image pi WHERE p.product_id=pi.product_id AND product_family=\"" . $_GET['family'] . "\" GROUP BY p.product_id ORDER BY product_name_$lang";
$r_getProduct = runQuery($q_getProduct);
while (list($id, $name, $number, $family, $image) = mysql_fetch_array($r_getProduct)){
?>
}
}
else {
?>
$q_getProduct = "SELECT p.product_id, p.product_name_$lang, p.product_number, p.product_family, pi.image_filename FROM Product_image pi LEFT JOIN Product p ON p.product_id=pi.product_id GROUP BY p.product_id ORDER BY RAND() LIMIT 0, 3";
$q_getProduct = "SELECT product_id, product_name_$lang, product_number, product_family FROM Product WHERE product_feature=1 ORDER BY RAND() LIMIT 0,3";
$r_getProduct = runQuery($q_getProduct);
/*
while (list($id, $name, $number, $family) = mysql_fetch_array($r_getProduct)){
$q_getImage = "SELECT image_filename FROM Product_image WHERE product_id=\"$id\" ORDER BY image_order ASC LIMIT 0,1";
$r_getImage = runQuery($q_getImage);
list($image) = mysql_fetch_array($r_getImage);
?>
}
*/
list($id, $name, $number, $family) = mysql_fetch_array($r_getProduct);
$q_getImage = "SELECT image_filename FROM Product_image WHERE product_id=\"$id\" ORDER BY image_order ASC LIMIT 0,1";
$r_getImage = runQuery($q_getImage);
list($image) = mysql_fetch_array($r_getImage);
?>
list($id, $name, $number, $family) = mysql_fetch_array($r_getProduct);
$q_getImage = "SELECT image_filename FROM Product_image WHERE product_id=\"$id\" ORDER BY image_order ASC LIMIT 0,1";
$r_getImage = runQuery($q_getImage);
list($image) = mysql_fetch_array($r_getImage);
?>
list($id, $name, $number, $family) = mysql_fetch_array($r_getProduct);
$q_getImage = "SELECT image_filename FROM Product_image WHERE product_id=\"$id\" ORDER BY image_order ASC LIMIT 0,1";
$r_getImage = runQuery($q_getImage);
list($image) = mysql_fetch_array($r_getImage);
?>