$table_name=explode("_",$g4['file_name']);
$tn=$table_name[0];
$t_table=$tn."_table";

/* 컬럼수를 지정*/
$colspan="10";


$sql_common = " from $g4[$t_table] ";
$sql_search = " where (1) ";
if ($stx) {
$sql_search .= " and ( ";
switch ($sfl) {
case "sm_no" :
$sql_search .= " ($sfl >= '$stx') ";
break;
case "sm_no" :
$sql_search .= " ($sfl = '$stx') ";
break;
case "sm_no" :
case "sm_no" :
$sql_search .= " ($sfl like '%$stx') ";
break;
default :
$sql_search .= " ($sfl like '$stx%') ";
break;
}
$sql_search .= " ) ";
}

//if ($is_admin == 'group') $sql_search .= " and mb_level = '$member[mb_level]' ";


if (!$sst) {
$sst = "sm_no";
$sod = "desc";
}

$sql_order = " order by $sst $sod ";

$sql = " select count(*) as cnt
$sql_common
$sql_search
$sql_order
";
$row = sql_fetch($sql);
$total_count = $row[cnt];


>> 우선 한테이블에값만 나오도록 수정했씁니다~


예전에 만든 조인문인데요

리스트는 잘나오다가 카운트에서 잘안나와서요~


$sql="select * from yo_member a join yo_salesman b on a.mb_id= b.mb_id $sql_order ";

저위에 값들 무시하고 이렇게 하니까 조인은 되는데

저위에 그누값에 조인문 넣을려면 어떻게 해야할까요??