=14 && $age<=19) mysql_query("UPDATE managa SET hit_a2=hit_a2+1 WHERE no=$no",$connect); if($age>=20 && $age<=29) mysql_query("UPDATE managa SET hit_a3=hit_a3+1 WHERE no=$no",$connect); if($age>=30) mysql_query("UPDATE managa SET hit_a4=hit_a4+1 WHERE no=$no",$connect); } } ///////////////// 조회수 처리 - 끝 $result=mysql_query("SELECT * FROM managa WHERE no='$no'",$connect); $row=mysql_fetch_array($result); $result2=mysql_query("SELECT * FROM zetyx_board_cas WHERE subject='$no'",$connect); $row2=mysql_fetch_array($result2); if($row[photo_img]) $row[photo_img]="img_data2/".$row[photo_img]; else $row[photo_img]="images/default_managa.png"; if($row[other_name]) $row[name]=stripslashes($row[name])." (".stripslashes($row[other_name]).")"; else $row[name]=stripslashes($row[name]); $result3=mysql_query("SELECT * from interestlist2 where managano='$no'"); $db_total=mysql_num_rows($result3); if($db_total>0) $interest="관심작가 : $db_total 명"; $result3=mysql_query("SELECT sum(A.number_comment) as tot_cnt, sum(A.score*A.number_comment) as sum_score FROM zetyx_board_score as A, comics as B WHERE A.subject=B.no and (B.managa_no like '%A".$no.",%' or managa_no like '%R".$no.",%' or managa_no like '%P".$no.",%')",$connect); $row3=mysql_fetch_array($result3); if($row3[tot_cnt]>0) $average="평균평점 : ".round(($row3[sum_score]/$row3[tot_cnt]),2).""; $starcomment="별점평가 : ".number_format($row3[tot_cnt])."개"; $result5=mysql_query("SELECT A.title, A.number_comment, A.score FROM zetyx_board_score as A, comics as B WHERE A.subject=B.no and (B.managa_no like '%A".$no.",%' or managa_no like '%R".$no.",%' or managa_no like '%P".$no.",%') and A.number_comment>=5 order by number_comment*score desc limit 2"); $total5=mysql_num_rows($result5); for($l=0;$l<$total5;$l++) { $row5=mysql_fetch_array($result5); $majorwork=$majorwork.addslashes($row5[title]).", "; } printHeader("desktop",$row[name],"대표작 : ".substr($majorwork,0,-2),"","","managa.php?no=$no"); printHeader("mobile",$row[name],"대표작 : ".substr($majorwork,0,-2),"","","managa.php?no=$no"); ?>
    성별 : 남자"; else if($row[gender]=='F') echo "
  • 성별 : 여자
    • "; } if($row[nation]) echo "
  • 국적 : $row[nation]
    • "; if($row[birth]) { echo "
  • 생년월일 : "; if(substr($row[birth],0,4)!="9999") echo substr($row[birth],0,4)."년 "; if(substr($row[birth],4,2)!="0") echo substr($row[birth],4,2)."월 "; if(substr($row[birth],6,2)!="0") echo substr($row[birth],6,2)."일 "; echo "
    • "; } if($row[debut_year]) echo "
  • 데뷔년도 : $row[debut_year] 년
    • "; if($row[debut_work]) echo "
  • 데뷔작품 : ".stripslashes($row[debut_work])."
    • "; if($row[homepage]) echo "
  • 홈페이지 : $row[homepage]
    • "; ?>
$average"; if($interest) echo " $interest"; if($starcomment) echo " $starcomment"; ?>