include '../include/config.php';
?>
$table = "journal_$org";
if(!$page){
$page=1;
}
if(!$sort){
$sort="title";
}
$searchkey=trim($searchkey);
$searchkey = str_replace(" & ", " and ", $searchkey);
$query = "SELECT COUNT(idx) AS COUNT FROM $table";
if($flag){
$query.= " WHERE 1=1 \n";
if($method==1){
//전방일치
$query.= " AND $search LIKE '$searchkey%' \n";
}else if($method==2){
//LIKE
$query.= " AND $search LIKE '$searchkey%' \n";
}else if($method==3){
//완전일치
$query.= " AND $search='$searchkey' \n";
}
if($media!=0){
$query.= " AND media='$media' \n";
}
}
//echo $query."
";
$result = mysql_query($query, $connect);
$res = mysql_fetch_array($result);
$t_count=$res[COUNT];
if($flag){
if($pageCount){
$listPerPage=$pageCount;
}
}
$start=($page-1)*$listPerPage;
if($t_count%$listPerPage==0){
$lastpage=intval($t_count/$listPerPage);
}else{
$lastpage=intval($t_count/$listPerPage)+1;
}
$query = "SELECT * \n";
$query.= "FROM $table \n";
if($flag){
$query.= " WHERE 1=1 \n";
if($method==1){
//전방일치
$query.= " AND $search LIKE '$searchkey%' \n";
}else if($method==2){
//LIKE
$query.= " AND $search LIKE '$searchkey%' \n";
}else if($method==3){
//완전일치
$query.= " AND $search='$searchkey' \n";
}
if($media!=0){
$query.= " AND media='$media' \n";
}
}
$query.= " ORDER BY $sort ASC 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]; ?>
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|