HTTP 500 error with MySQL INSERT and UPDATE queries
Posted: Thu Sep 21, 2017 11:10 pm
I'm getting this error when the string I'm trying to insert or update in my table contains the text "create a table x" where "x" can be anything at all. The same happens if the text contains "create table x". I'm guessing that the text is interpreted as part of the SQL query, but I can't find any references to this problem to figure out how to correct it. This is happening with $full_details in the code below:
Any help figuring this out will be greatly appreciated.
Code: Select all
mysqli_query($dbi,"UPDATE tracker_submits SET
full_details='$full_details',
updater='$_SESSION[id]',
updatestamp='$timestamp'
WHERE submit_id='$postid'") or die(mysqli_connect_error()." Oops! Error Updating Post.");