Jump to content

ccrandall

New Members
  • Content Count

    4
  • Joined

  • Last visited

Community Reputation

0 Neutral

About ccrandall

  • Rank
    Newbie
  1. Than you Staff Alumni, that is what it was the fact I missed putting the u before 104. as for the hash and verification I didn't put those parts in the code that is on here because they work just fine and would compromise my site which has to be HIPPA compliant, I just showed the part that was relevant to the question and problem that I was having. I am still used to the old style MySQL not the new MySQLli format where I had to update the whole row. Thank You Again Guys Christopher J. Crandall
  2. $sql = "UPDATE ".$d203." SET u102='".$newPassword."', u103='N' WHERE 104=".$a104; print("<br> ".$sql."<br>"); if ($conn->query($sql) === TRUE) { print ("<script type='text/javascript'> alert('Your password has been updated'); </script>"); } else { echo "Error updating record: " . $conn->error; print ("<script type='text/javascript'> alert('Sorry something went wrong please try to change the password again'); </script>"); } $conn->close(); here is the code to update the record but it keeps not updating even though it says it has and
  3. I have made a rather simple error that I did fix with the column names just being numbers, I fixed this by adding a letter before the numbers. now everything seems to go through correctly I don't get any errors but the database isn't updated. any suggestions?
  4. I'm writing code to update 2 cells of an sql table and I'm getting a syntax error with the following line of code UPDATE afdt3235 SET 102='NdNicSg98NkM9cEZB7/SNQ==', 103='N' WHERE 104='42' I'm currently using: Server type: MariaDB Server version: 10.1.22-MariaDB - mariadb.org binary distribution Protocol version: 10 Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/7.1.4 Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $ PHP version: 7.1.4 here is the entire error that I am getting: Error updating record: You have an error in
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.