CODEWITHSUNDEEP
phpmysqli
yureka
yureka

Reputation: 99

Database being not updated

mysqli_query($connect,"UPDATE student SET name='$name' rollnumber='$nrollnumber' mark='$mark' department='$department' WHERE rollnumber='$rollnumber'");

is there any quotes rule violation in the code.because the DB is not being updated.

Upvotes: 0

Views: 36

Answers (2)

Krishna Gupta
Krishna Gupta

Reputation: 685

mysqli_query($connect,"UPDATE student SET name='".$name."', rollnumber='".$nrollnumber."', mark='".$mark."', department='".$department."', WHERE rollnumber='".$rollnumber."'");

Upvotes: 0

Maha Dev
Maha Dev

Reputation: 3965

You are missing comma's,

mysqli_query($connect,"UPDATE student SET name='$name',rollnumber='$nrollnumber', mark='$mark', department='$department' WHERE rollnumber='$rollnumber'");

Upvotes: 2

Related Questions