} getLink($THIS_FILE . "?sql=" . $sql, "처리되었습니다.", $history); } $month = $year ? $month : ''; $day = $month ? $day : ''; $p = $p ? $p : 1; $recnum = $recnum ? $recnum : 20; $sort = $sort ? $sort : 'MB_UID'; $orderby = $orderby ? $orderby : 'DESC'; $MB_GROUP = getMemberGroup(); $WHEREIS = "WHERE MB_REGISDAY LIKE '" . $year . $month . $day . "%' AND MB_FLAG='1'"; if (!$sql) { if (!$query) { $WHEREIS .= $mb_type != '' ? "AND MB_TYPE='" . $mb_type . "' " : ''; $WHEREIS .= $mb_sex != '' ? "AND MB_SEX='" . $mb_sex . "' " : ''; $WHEREIS .= $mb_age != '' ? "AND LEFT(MB_BIRTH,4) BETWEEN '" . getAgeToYear($mb_age, 1) . "' AND '" . getAgeToYear($mb_age, 2) . "'" : ''; $WHEREIS .= $mb_job != '' ? "AND MB_JOB='" . $mb_job . "' " : ''; $WHEREIS .= $mb_marr != '' ? "AND MB_MARR='" . $mb_marr . "' " : ''; $WHEREIS .= $mb_birth != '' ? "AND MB_BIRTH LIKE '%" . $mb_birth . "%' " : ''; $WHEREIS .= $mb_addr != '' ? "AND MB_ADDR1 LIKE '%" . $mb_addr . "%' " : ''; $WHEREIS .= $mb_log ? "AND MB_NOWLOG='1' " : ''; $WHEREIS .= $where != '' && $keyword != '' ? "AND " . $where . " LIKE '%" . $keyword . "%' " : ''; } else { $WHEREIS = "WHERE " . getNewSql($del_id); } } else { $WHEREIS = urldecode(stripslashes($sql)); } $MBR_QUE = "SELECT * FROM kimsmall7_members " . $WHEREIS . " ORDER BY " . $sort . " " . $orderby . " LIMIT " . ($p - 1) * $recnum . ", " . $recnum; $MBR_DATA = db_query($MBR_QUE, $DB_CONNECT); $DATA_NUM = db_fetch_array(db_query("SELECT count(*) FROM kimsmall7_members " . $WHEREIS, $DB_CONNECT));
<?php $arr = array("00~15", "16~20", "21~25", "26~30", "31~35", "36~40", "41~45", "46~50", "51~55", "56~60", "60~99"); $num = sizeof($arr); $TOT = db_fetch_array(db_query("SELECT count(*) FROM kimsmall7_members WHERE MB_REGISDAY LIKE '" . $year . $month . $day . "%' " . $WHEREIS, $DB_CONNECT)); for ($i = 0; $i < $num; $i++) { $NUM = db_fetch_array(db_query("SELECT count(*) FROM kimsmall7_members WHERE MB_REGISDAY LIKE '" . $year . $month . $day . "%' AND LEFT(MB_BIRTH,4) BETWEEN '" . getAgeToYear($arr[$i], 1) . "' AND '" . getAgeToYear($arr[$i], 2) . "'" . $WHEREIS, $DB_CONNECT)); $per = @round($NUM[0] / $TOT[0] * 100, 1); $width = (int) $per * 5; ?> <tr height=20> <td bgcolor=efefef><img src='./module/WebLog/image/blank.gif' width=5 height=1></td> <td bgcolor=efefef title="<?php echo getAgeToYear($arr[$i], 2); ?> ~<?php echo getAgeToYear($arr[$i], 1); ?> 년생"><img src='./module/WebLog/image/blank.gif' width=95 height=1><br><a onclick="MonthChange('mb_age=<?php echo $arr[$i]; ?> ')"><font class='Blink'><?php echo $arr[$i]; ?> 세</font></a></td> <td width=90%><img src='./module/WebLog/image/grp1.gif' height='10' width='<?php echo $width; ?> '> <?php if ($NUM[0]) { ?>