$sql="SELECT count(*) as TableCount FROM $TableName";
}
else
$sql="SELECT count(*) as TableCount FROM $TableName INNER JOIN ".GetTablePrefix()."CategoryItems ON ".GetTablePrefix()."CategoryItems.ItemResourceId=$TableName.ResourceId";
if(strlen($where)>0)
$sql.=" WHERE ".$where;
$rs=$db->Execute($sql);
// echo "SQL TABLE COUNT: ".$sql."<br>\n";
$res=$rs->fields["TableCount"];
return$res;
}
FunctionQueryCount($sql)
{
$sql=preg_replace('/SELECT(.*)FROM[ \n\r](.*)/is','SELECT COUNT(*) AS TableCount FROM $2',$sql);