5){ err_msg_db(37); }else{ $Y=date(m).'.'.date(d).'.'.date(y); $you_cat = addslashes($you_cat); // ���� // ����ī�װ� �̸� �˾� ���� $query0="select * from sv_scategory where scatenum=$sc2"; if(!$sc2){ err_msg('Select Step 1 and Step 2 !'); } $result0 = mysqli_query($query0); $catcate12name = mysqli_fetch_array($result0); mysql_free_result($result0); $user_code = $user_cat[user_code] + 1; // input user code number /// 9999 �̻��϶� ó�� if($user_code>9999){ // �� user_code �˾� ���� $query_user_code="select * from sv_scategory where (user_catename='0') and (scatedep='3') order by num "; $result_user_code = mysqli_query($query_user_code); $total_re_code= mysqli_num_rows($result_user_code); if($total_re_code=='0'){ err_msg_db(38); } $row_user_code = mysqli_fetch_array($result_user_code); mysql_free_result($result_user_code); // ����� ī�װ� ����Ÿ user_code �����Է� $query1 = "update sv_scategory set scatenum = '$catcate12name[scatenum]' , scatename = '$catcate12name[scatename]' , sparent = '$catcate12name[sparent]' , sparentname = '$catcate12name[sparentname]' , user_id = '$user_id' , user_code = '$row_user_code[user_code]' , user_catename = '$you_cat' , scatedep = '3' , regdate = '$Y' where num='$row_user_code[num]' "; // ���� �� } else { // ����� ī�װ� ����Ÿ �Է�(���ο� �Է�) if($you_cat=='0'){ err_msg(" Your catename must not be 0 "); } $query1 = "insert sv_scategory set scatenum = '$catcate12name[scatenum]' , scatename = '$catcate12name[scatename]' , sparent = '$catcate12name[sparent]' , sparentname = '$catcate12name[sparentname]' , user_id = '$user_id' , user_code = '$user_code' , user_catename = '$you_cat' , scatedep = '3' , regdate = '$Y' "; } mysqli_query($query1); } } else if ($mode == "delete") { $query2 = "update sv_scategory set user_catename='0' where (user_id= '$user_id') and (num='$num')"; mysqli_query($query2); } ?>