Would appreciate any help for a novice...
I have a table ("Scores") with the following fields:
idAbstract, title, R1, R2, R3,...R8
where R1 through R8 are reviewers for a document.
A script logs in R1 and pulls his/her $reviewerID (value="R1") from a permissions table.
R1 reviews the document and a script creates an integer score for the document. $abstract_score must then be placed in the R1 field from "Scores" for record idAbstract.
What is wrong with the syntax of the following UPDATE statement?
$sql = "UPDATE Scores SET $reviewerID='$abstract_score' WHERE idAbstract='$idAbstract'";
I've tried several different solutions without success. It is probably something very simple.
Many thanks!
