PHP MySQL Statement not working, no errors

Question

I'm working on a website, and I have encountered with an strange MySQL behaviour. I'm trying to use an MySQL Update Query with multiple WHERE Clauses.

$name = $_POST['username'];
$updatequery1 = "UPDATE OTP SET 'Project' = 'ANETSignupUsed' WHERE Name = '$name' AND HashedOTP = '$hashedotp' ";
$sqlconnection->query($updatequery1);
die("DONE");

Note that I've already defined $hashedotp.

When I try doing the same thing in MySQL Console it works pretty well, and I've made sure that the user used to define $sqlconnection has Update rights.

I've tried solutions DESCRIBED

HERE
HERE

I've spent hours searching about it, but to no avail.

Thanks a lot in advance!

$updatequery1 = "UPDATE OTP SET Project = 'ANETSignupUsed' WHERE Name = '$name' AND HashedOTP = '$hashedotp' "; try with this query. — HP371, Dec 25 '19 at 13:14
Uh..... it did work! I don't know why but it didn't work a few minutes ago! — HufF867, Dec 25 '19 at 13:18

score 0 · Accepted Answer · answered Dec 25 '19 at 13:20

0

Try this Remove single quote from your query

$updatequery1 = "UPDATE OTP SET Project = 'ANETSignupUsed' WHERE Name = '$name' AND HashedOTP = '$hashedotp' ";

answered Dec 25 '19 at 13:20

VIKAS KATARIYA

5,867
3
17
34

Please give upvote this answer Thank you!!!! @Arag Aggrawal – VIKAS KATARIYA Dec 25 '19 at 15:05

PHP MySQL Statement not working, no errors

1 Answers1