include '../include/config.php';
?>
$table = "journal_$org";
if(!$page){
$page=1;
}
$query = "SELECT count( db ) AS COUNT \n";
$query .= "FROM ( \n";
$query .= " SELECT db FROM $table WHERE db <> '' GROUP BY db \n";
$query .= " ) AS A";
//echo $query."
";
$result = mysql_query($query, $connect);
$res = mysql_fetch_array($result);
$t_count=$res[COUNT];
$start=($page-1)*$listPerPage;
if($t_count%$listPerPage==0){
$lastpage=intval($t_count/$listPerPage);
}else{
$lastpage=intval($t_count/$listPerPage)+1;
}
$query = "SELECT count(*) AS COUNT, db \n";
$query.= "FROM $table WHERE db <> '' \n";
$query.= "GROUP BY db \n";
$query.= "ORDER BY db LIMIT $start,$listPerPage";
//echo $query."
";
$result = mysql_query($query, $connect);
$start_no=($listPerPage*($page-1))+1;
?>
//include 'top_nav.html';
?>
$path="../admin/logo/";
$logo="";
$query = "SELECT * FROM org where id='$org'";
//echo $query." "; $result_logo = mysql_query($query, $connect); $res_logo = mysql_fetch_array($result_logo); $logo=$res_logo[logo]; ?>
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|