userid ); $show_comment_form = 1; $URI = explode("/",$_SERVER['REQUEST_URI']); $ID = cleanVar($URI[3]); if($_SERVER['REQUEST_METHOD'] == 'POST') { extract($_POST); if($comment_comment) { $comment_comment = db_post($comment_comment); $DB->base_Query("INSERT INTO comments (user_id,article_id,comment,dttm) VALUES ('$userid','$ID','$comment_comment','" . time() . "')"); $show_comment_form=0; $comment_message = "Thanks! Your comment has been submitted. Once approved it will be posted with this article."; } } if($ID) { $q = validateQuery("SELECT * FROM article WHERE approved = '1' AND id = '$ID' LIMIT 1"); $DB->base_Query($q); $row = $DB->base_Fetch_Array(); extract($row); $art = "

" . db_clean($title) . "

\n"; $art .= db_clean($content); $article_title_tag = " : " . db_clean($title); } else { $ars = array(); $q = "SELECT * FROM article WHERE approved = '1' ORDER BY dttm DESC"; $q = validateQuery($q); $DB->base_Query($q); while( $row = $DB->base_Fetch_Array() ) { array_push($ars,$row); } $num_ars = count($ars); for($i=0; $i < $num_ars; $i++) { $DB->base_Query("SELECT count(*) FROM comments WHERE article_id = '" . $ars[$i]['id'] . "' AND approved = '1'"); $row = $DB->base_Fetch_Array(); $comment_count = $row[0]; $art .= "
\n"; $art .= "" . $ars[$i]['title'] . "
\n"; if($ars[$i]['user_id']) { $user_info = getUserInfo($ars[$i]['user_id']); $post_name = "" . db_clean($user_info['disp_name']) . ""; } else { $post_name = "Management"; } $art .= "posted by $post_name on " . date('F jS',$ars[$i]['dttm']) . "
\n"; $art .= strip_tags(db_clean($ars[$i]['descr'])); $art .= "

read full article       leave a comment ($comment_count)

\n"; $art .= "
\n"; } } commonHeader("Fly Fishing Articles $article_title_tag",1); ?> isLoggedIn()); ?>
isLoggedIn()); ?>

Fly Fishing Articles

« Back to Articles

isLoggedIn()) { ?> Submit your article to ! Login or Create Account to write an article for .



Comments


base_Query($q); while($row = $DB->base_Fetch_Array()) { extract($row); $user_photo_msg = ($photo) ? "" : ""; ?>

posted by on

     Visit profile   |   Send message

isLoggedIn()) { ?>



Login or Create Account to post a comment for this article.