New and Used Climbing, Hiking, Camping, Biking, Ski and Snowboard Gear for
Sale.
MountainWeb.com members can list their new and used
gear for sale for free on our site. That's what the mountain community is
all about! So pick up your next piece of rock climbing pro, ski jacket or
climbing boots from another member and save the cash for gas money to your
next base camp.
<%
java.sql.Statement FOURTEENER1stmt = conn.createStatement();
java.sql.ResultSet FOURTEENER1rs = FOURTEENER1stmt.executeQuery("Select * FROM MEMBER_GEAR where Category='CLOTHING'");
while(FOURTEENER1rs.next()) {
String id = FOURTEENER1rs.getString("ItemNum");
String item = FOURTEENER1rs.getString("Item");
String desc = FOURTEENER1rs.getString("description").substring(0, 45);
%>
<%=item%>
<% }
FOURTEENER1rs.close();
FOURTEENER1stmt.close();
%>
<%
java.sql.Statement stmt1 = conn.createStatement();
java.sql.ResultSet rs1 = stmt1.executeQuery("Select * FROM MEMBER_GEAR where Category='EQUIPMENT'");
while(rs1.next()) {
String id = rs1.getString("ItemNum");
String item = rs1.getString("Item");
String desc = rs1.getString("description").substring(0, 45);
%>
<%=item%>
<% }
rs1.close();
stmt1.close();
%>
<%
java.sql.Statement stmt11 = conn.createStatement();
java.sql.ResultSet rs11 = stmt11.executeQuery("Select * FROM MEMBER_GEAR where Category='shoes'");
while(rs11.next()) {
String id = rs11.getString("ItemNum");
String item = rs11.getString("Item");
String desc = rs11.getString("description").substring(0, 45);
%>
<%=item%>
<% }
rs11.close();
stmt11.close();
%>
<%
java.sql.Statement stmt12 = conn.createStatement();
java.sql.ResultSet rs12 = stmt12.executeQuery("Select * FROM MEMBER_GEAR where Category='GEARWTD'");
while(rs12.next()) {
String id = rs12.getString("ItemNum");
String item = rs12.getString("Item");
String desc = rs12.getString("description").substring(0, 45);
%>
<%=item%>
<% }
rs12.close();
stmt12.close();
%>