".$sSQL);
$arr_product=array();
while($row = mysql_fetch_assoc($result)){
$arr_product[$row['productsID']]=$row['title']." - ".$row['m_title'];}
$sSQL="SELECT blogID, dateCreated, fname, email, comment, productsID, parentID, category_forum FROM blog WHERE approved='1' AND parentID=0 ";
if(!empty($_SESSION['productsID_forum_sess'])){ $sSQL.=" AND productsID='".toSQL($_SESSION['productsID_forum_sess'])."'";}
if(!empty($_SESSION['category_forum_view_sess'])){ $sSQL.=" AND category_forum='".toSQL($_SESSION['category_forum_view_sess'])."'";}
$sSQL.=" ORDER BY dateCreated DESC";
$result = mysql_query($sSQL) or die("err: " . mysql_error().$sSQL);
$pageItems=20; $pageNum=empty($_REQUEST['pageNum'])?'1':$_REQUEST['pageNum'];
$total=mysql_num_rows($result);
if($pageItems*($pageNum-1)>$total)$pageNum=0;
if($total>0)$rr=mysql_data_seek($result, $pageItems*($pageNum-1));
$s_blogID="";
$ii=0;
while($row = mysql_fetch_assoc($result)){$ii++;
if($ii>$pageItems)break;
$s_blogID.=$row['blogID'].",";
}
$arr_replays=array();
if(!empty($s_blogID)){
$s_blogID=substr($s_blogID, 0, -1);
$sSQL="SELECT * FROM blog WHERE parentID IN ($s_blogID)";
$result1 = mysql_query($sSQL) or die("err: " . mysql_error().$sSQL);
while($row1 = mysql_fetch_assoc($result1)){
$arr_replays[$row1['parentID']][$row1['blogID']]['fname']=$row1['fname'];
$arr_replays[$row1['parentID']][$row1['blogID']]['email']=$row1['email'];
$arr_replays[$row1['parentID']][$row1['blogID']]['dateCreated']=$row1['dateCreated'];
$arr_replays[$row1['parentID']][$row1['blogID']]['comment']=$row1['comment'];
$arr_replays[$row1['parentID']][$row1['blogID']]['productsID']=$row1['productsID'];
}
}
if($pageItems*($pageNum-1)>$total)$pageNum=0;
if($total>0)$rr=mysql_data_seek($result, $pageItems*($pageNum-1));
?> | |