SoftTree Blog

= 4) { $_SESSION['userid'] = $arr[0]; $_SESSION['level'] = $arr[1]; $_SESSION['status'] = $arr[2]; $_SESSION['username'] = $arr[3]; session_regenerate_id(); } else die("Error: Incorrect session id"); } dbconnect (); if(isset($_GET['catid'])) { if ((int)$_GET['catid'] != 0) { $cat_filter = " AND a.categoryID = " . (int)$_GET['catid']; } } if(isset($_GET['ym'])) { $query1="SELECT replace(replace(a.title,'\\\\\"', '\"'), '\\\\''', '''') as title, replace(replace(a.comments,'\\\\\"', '\"'), '\\\\''', '''') as comments, a.categoryID, a.date_posted, a.artid, c.category, a.name as uname, DATE_FORMAT(a.date_posted,'%W,%d %b %Y') as thedate FROM blog_article a INNER JOIN blog_categories c ON a.categoryID=c.catid WHERE cast(date_format(a.date_posted, '%Y%m') AS UNSIGNED) = ". (int)$_GET['ym'] . $cat_filter . " ORDER BY a.date_posted DESC"; } else { $query1="SELECT replace(replace(a.title,'\\\\\"', '\"'), '\\\\''', '''') as title, replace(replace(a.comments,'\\\\\"', '\"'), '\\\\''', '''') as comments, a.categoryID, a.date_posted, a.artid, c.category, a.name as uname, DATE_FORMAT(a.date_posted,'%W,%d %b %Y') as thedate FROM blog_article a INNER JOIN blog_categories c ON a.categoryID=c.catid WHERE a.artchild='0'" . $cat_filter . " ORDER BY a.date_posted DESC LIMIT 10 "; } $blogarticles = mysql_query($query1) or die(mysql_error()); $num = mysql_num_rows($blogarticles); ?> SoftTree Blog

Home"; else $home = "Home"; if (isset($_SESSION['username'])) { if ($_SESSION['level'] == "admin") $links = "$home | Administration | Logout"; else $links = "$home | Logout"; } else $links = "$home | Login"; ?>

0){ while($row_articles = mysql_fetch_assoc($blogarticles)){ ?>

Posted by

... (more)

Date posted: | Comments()

There are no articles available at present