Dim doing, msgdoing = Request.QueryString("do")If doing = "edit" Then u_ime = Request.Form("ime") u_email = Request.Form("email") u_lozinka = Request.Form("lozinka") u_adresa = Request.Form("adresa") u_zip = Request.Form("zip") u_grad = Request.Form("grad") u_telefon = Request.Form("telefon") u_mobitel = Request.Form("mobitel") If u_ime = "" OR u_email = "" Then msg = "Required fields !" If u_telefon = "" AND u_mobitel = "" Then msg = "Required fields" Else If u_lozinka = "" Then strSQL = "UPDATE tblKorisnici SET [ime] = '" & u_ime & "', [email] = '" & u_email & "', adresa = '" & u_adresa & "', [zip] = " & u_zip & ", grad = '" & u_grad & "', telefon = '" & u_telefon & "', mob = '" & u_mobitel & "' WHERE id = " & Request.Cookies("enekretnine")("user_id") & ";" dbConn.Execute(strSQL) msg = "Succses !" Else strSQL = "UPDATE tblKorisnici SET [ime] = '" & u_ime & "', [email] = '" & u_email & "', lozinka = '" & u_lozinka & "', adresa = '" & u_adresa & "', [zip] = " & u_zip & ", grad = '" & u_grad & "', telefon = '" & u_telefon & "', mob = '" & u_mobitel & "' WHERE id = " & Request.Cookies("enekretnine")("user_id") & ";" dbConn.Execute(strSQL) msg = "Succes !" End if End if End ifElse Set rsGetUserData = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT * FROM tblKorisnici WHERE id = " & Request.Cookies("enekretnine")("user_id") & ";" rsGetUserData.Open strSQL, dbConn If rsGetUserData.EOF Then Response.Redirect "default.asp" Else ime = rsGetUserData("ime") email = rsGetUserData("email") adresa = rsGetUserData("adresa") zip = rsGetUserData("zip") grad = rsGetUserData("grad") telefon = rsGetUserData("telefon") mob = rsGetUserData("mob") End ifEnd if
Why that code is not working. Why my database table wont update. I get no error, but my table fileds remain the same. Pls help