"; print ""; $past_product=""; $query="SELECT * from prod ORDER BY product"; $result = MYSQL_QUERY($query); $number = MYSQL_NUMROWS($result); IF ($number == 0) : ELSEIF ($number > 0) : WHILE ($i < $number): $product = mysql_result($result,$i,"product"); $supplier = mysql_result($result,$i,"supplier"); $link = mysql_result($result,$i,"link"); $letter = substr($product,0,1); $icon = mysql_result($result,$i,"icon"); IF ($past_product == $product) print ""; ELSE print ""; $past_product = $product; print ""; IF ($icon=="") print ""; else print ""; $i++; ENDWHILE; ENDIF; print "


Searching for a particular type of product is as easy as clicking on a letter which will link you to our manufactures. If you don't see a product category just click on the "?". We'll ask you a couple of quick questions so we can quickly provide you with the information.


A B C D E F G H I J K L M N O P Q R S T U V W X Y Z ?
ProductSupplier
(click for more information)
$product
[ top ]
$supplier
"; ?>