I have the following statement:
mysqli_prepare($link, "UPDATE tresults SET q31_red = ?, q31_theme = ? WHERE result_id = ?;");
The above is fine but I need the 31 element to be a variable, have tried the below but not joy:
mysqli_prepare($link, "UPDATE tresults SET q".$qn."_red = ?, q".$qn."_theme = ? WHERE result_id = ?;");
No joy - I'm sure this should be possible, any suggestions?
