"; for($c=0;$c< $num_results;$c++) { print "
"; print "
"; print "
"; print mysql_result($catresult,$c,'category')."
"; print "
"; print "
"; } print "
"; ?>
Search by Product:
"; print "
--Select One--
"; $query = "select * from subcategory order by subcategory asc"; $result = mysql_query($query,$db) or die ("error in query: $query.".mysql_error()); $num_results = mysql_num_rows($result); for($i=0;$i< $num_results;$i++) { $subcategory=mysql_result($result,$i,'subcategory'); $thisvalue=mysql_result($result,$i,'subcategoryId'); print "
".$subcategory."
"; print "
".$thisvalue; } print ""; ?>
Search by Style Number:
CONTACT INFORMATION HERE
Copyright © 2004 Spirit Products
Ltd All Rights Reserved
