%@ page import="java.sql.*" %>
<%@ include file="/dbconn/dbconn.inc" %>
<%
String query = "Select * from content WHERE guid=?";
java.sql.PreparedStatement RCstmt = conn.prepareStatement(query);
RCstmt.setString(1, request.getParameter("snowboarding"));
java.sql.ResultSet RCrs = RCstmt.executeQuery();
String img = "";
while(RCrs.next()) {
String id = RCrs.getString("guid");
String imgSml = RCrs.getString("path");
String imgTmp = RCrs.getString("path_large");
if (imgTmp != null){
img = imgTmp;
} else { img = imgSml; }
String content_title = RCrs.getString("content_title").trim();
String content_abstract = RCrs.getString("content_abstract").trim();
String content_body = RCrs.getString("content_body");
String pub_date = RCrs.getString("pub_date");
%>
<%=content_title%>
<%=content_title%>
<%=content_body%>
<%}
RCrs.close();
RCstmt.close();
%>
|
|
<%
String queryChild = "Select * from content WHERE parent_id=?";
java.sql.PreparedStatement Childstmt = conn.prepareStatement(queryChild);
Childstmt.setString(1, request.getParameter("id"));
java.sql.ResultSet Childrs = Childstmt.executeQuery();
while(Childrs.next()) {
String childID = Childrs.getString("guid");
String child_title = Childrs.getString("content_title");
%>
<%=child_title%>--->
<% }
Childrs.close();
Childstmt.close();
%>
|
|
<%@ include file="/includes/header.jsp" %>
<%@ include file="/includes/left_nav.jsp" %>