<% username = Request.Cookies("junooni_userid") level = Request.Cookies("junooni_level") %> <% 'Get data from form varuserid = Request.form("Userid") page = Request.form("page") varfname = Request.form("firstname") varlname = Request.form("lastname") varfname = Request.form("firstname") varemail = Request.form("email") varcity = Request.form("city") varcountry = Request.form("country") varstate = Request.form("state") varage = Request.form("mm")&"/"& Request.form("dd")&"/"& Request.form("yy") vargender = Request.form("gender") varMarStatus = Request.form("MarStatus") varOccupation = Request.form("Occupation") varSignature = Request.form("Signature") varemailhidden = Request.form("hidden") 'Optional varhomepage = Request.form("homepage") varcoollink = Request.form("coollink") varpic_url = Request.form("photo_url") varbio = Request.form("bio") varhobbies = Request.form("hobbies") varlnews = Request.form("lnews") varquote = Request.form("quote") varpage = Request.form("page") %>
Update profile
<% Call Connjunooni(Conn) Set rsUser = Server.CreateObject("ADODB.Recordset") rsUser.open "select * from users where username = '"&varuserid&"'", conn, 3, 3 rsUser("firstname") = varfname rsUser("lastname") = varlname rsUser("email") = varemail rsUser("city") = varcity rsUser("state") = varstate rsUser("country") = varcountry rsUser("dateofbirth") = varage rsUser("gender") = vargender rsUser("mar_status") = varmarstatus rsUser("Occupation") = varOccupation rsUser("Signature") = varSignature rsUser("homepage") = varhomepage rsUser("coollink") = varcoollink rsUser("pic_url") = varpic_url rsUser("bio") = varbio rsUser("hobbies") = varhobbies rsUser("lastnews") = varlnews rsUser("emailhidden") = varemailhidden rsUser("favoritequote") = varquote rsUser.Update %>

Your profile has been changed.

Click here to continue