I am currently having an issue getting the following code to update MySQLi after the user inputs in a text type form:
print "<input type='text' name='prof' >Prof<br />";
$profselectorX=$_POST['prof'];
$profselector=$mysqli->real_escape_string($profselectorX);
$query="UPDATE homework1 SET 'prof'='".$profselector."' WHERE idnumber='".$editselector."'";
$resultz=$mysqli->query($query) or die($mysqli->error);
Thank you in advance!
Rewrite your query like this
$query="UPDATE `homework1` SET `prof`='$profselector' WHERE `idnumber`='$editselector'";