processQuery("SELECT * FROM categories"); while($result = $cat_query->fetch_array()){ $data[0] = $result[0]; $data[1] = $result[1]; } if(isset($_SESSION["grade"])){ $prod_query = $dbObject->processQuery("SELECT * FROM products WHERE grade LIKE '%$grade%'"); }else{ $prod_query = $dbObject->processQuery("SELECT * FROM products"); } session_destroy(); while($result = $prod_query->fetch_array()){ $id [] = $result[2]; $name[] = $result[1]; $short_desc[] = $result[4]; $grades[] = $result[8]; $image[] = $result[9]; $url[] = $result[13]; } $grade_query = $dbObject->processQuery("SELECT * FROM grade"); ?> Pure Filters - All Filters

Filter

Product Grade
processQuery("SELECT * FROM grade"); while($result = $grade_q->fetch_array()){ echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } ?>
Grade 0.1 0.5 1 5 10 50 100
Particle Size (Microns)
\n"; echo $result["grade"]; echo " \n"; echo $result["0.1"]; echo " \n"; echo $result["0.5"]; echo " \n"; echo $result["1"]; echo " \n"; echo $result["5"]; echo " \n"; echo $result["10"]; echo " \n"; echo $result["50"]; echo " \n"; echo $result["100"]; echo "

All Filters

Search Criteria Produced No Results
"; }else{ foreach($name as $index => $name) { $category_query = $dbObject->processQuery("SELECT * FROM categories WHERE id = $id[$index]"); while($result = $category_query->fetch_array()){ $cat_url = $result[2]; } echo "
"; echo "
"; echo "

$name

"; echo "

" . limit_words($short_desc[$index],28) . "...

"; echo "view more"; echo "
"; } } ?>