Editing: culture_add.asp

<!--#INCLUDE FILE="Connectdb.asp"--> <!--#INCLUDE FILE="chk_login.asp"--> <% id_year=request.form("id_year") id_m=request.form("id_m") project_n=request.form("project_n") picture_link=request.form("picture_link") sqlcy="select * from culture_year where id_year='"&id_year&"'" set orscy=server.createobject("adodb.recordset") orscy.open sqlcy,conn,1,3 if orscy.eof then sqliy="insert into culture_year(id_year) values('"&id_year&"')" set orsiy=server.createobject("adodb.recordset") orsiy.open sqliy,conn,1,3 end if date_mo=now sqlnews="select * from culture_detail" set orsnews=server.createobject("adodb.recordset") orsnews.open sqlnews,conn,1,3 if not orsnews.eof then orsnews.movelast id_project=orsnews("id_project") id_project=id_project+1 else id_project=1 end if 'response.write "<br>"&id_project&"bb" sqldata="insert into culture_detail(id_year,id_project,id_m,project_n,datemo,picture_link) values('"&id_year&"',"&id_project&",'"&id_m&"','"&project_n&"','"&date_mo&"','"&picture_link&"')" set orsdata=server.createobject("adodb.recordset") orsdata.open sqldata,conn,1,3 ' response.write id_project ' response.write sqldata response.write "<meta http-equiv='refresh' content ='0;url=culture_detail.asp?id="&id_project&"'>" %>