morocco-iceberg Posted May 31, 2010 Share Posted May 31, 2010 I keep getting this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE paragraph_one='a'' at line 1 But I've gone through my code and can't find what is wrong... the code is quite long so I've only posted what I think are the relevant sections. (The error occurs whilst trying to process if(isset($_POST["update"])).) <?php if(isset($_POST["update"])){ $x = mysql_real_escape_string($_POST["update"]); $paragraph_one = mysql_real_escape_string($_POST["paragraph_one"]); $paragraph_two = mysql_real_escape_string($_POST["paragraph_two"]); $paragraph_three = mysql_real_escape_string($_POST["paragraph_three"]); $paragraph_four = mysql_real_escape_string($_POST["paragraph_four"]); $question_one = mysql_real_escape_string($_POST["question_one"]); $question_one_correct = mysql_real_escape_string($_POST["question_one_correct"]); $answer_one_a = mysql_real_escape_string($_POST["answer_one_a"]); $answer_one_b = mysql_real_escape_string($_POST["answer_one_b"]); $answer_one_c = mysql_real_escape_string($_POST["answer_one_c"]); $answer_one_d = mysql_real_escape_string($_POST["answer_one_d"]); $question_two = mysql_real_escape_string($_POST["question_two"]); $question_two_correct = mysql_real_escape_string($_POST["question_two_correct"]); $answer_two_a = mysql_real_escape_string($_POST["answer_two_a"]); $answer_two_b = mysql_real_escape_string($_POST["answer_two_b"]); $answer_two_c = mysql_real_escape_string($_POST["answer_two_c"]); $answer_two_d = mysql_real_escape_string($_POST["answer_two_d"]); $question_three = mysql_real_escape_string($_POST["question_three"]); $question_three_correct = mysql_real_escape_string($_POST["question_three_correct"]); $answer_three_a = mysql_real_escape_string($_POST["answer_three_a"]); $answer_three_b = mysql_real_escape_string($_POST["answer_three_b"]); $answer_three_c = mysql_real_escape_string($_POST["answer_three_c"]); $answer_three_d = mysql_real_escape_string($_POST["answer_three_d"]); $question_four = mysql_real_escape_string($_POST["question_four"]); $question_four_correct = mysql_real_escape_string($_POST["question_four_correct"]); $answer_four_a = mysql_real_escape_string($_POST["answer_four_a"]); $answer_four_b = mysql_real_escape_string($_POST["answer_four_b"]); $answer_four_c = mysql_real_escape_string($_POST["answer_four_c"]); $answer_four_d = mysql_real_escape_string($_POST["answer_four_d"]); $question_five = mysql_real_escape_string($_POST["question_five"]); $question_five_correct = mysql_real_escape_string($_POST["question_five_correct"]); $answer_five_a = mysql_real_escape_string($_POST["answer_five_a"]); $answer_five_b = mysql_real_escape_string($_POST["answer_five_b"]); $answer_five_c = mysql_real_escape_string($_POST["answer_five_c"]); $answer_five_d = mysql_real_escape_string($_POST["answer_five_d"]); $question_six = mysql_real_escape_string($_POST["question_six"]); $question_six_correct = mysql_real_escape_string($_POST["question_six_correct"]); $answer_six_a = mysql_real_escape_string($_POST["answer_six_a"]); $answer_six_b = mysql_real_escape_string($_POST["answer_six_b"]); $answer_six_c = mysql_real_escape_string($_POST["answer_six_c"]); $answer_six_d = mysql_real_escape_string($_POST["answer_six_d"]); $question_seven = mysql_real_escape_string($_POST["question_seven"]); $question_seven_correct = mysql_real_escape_string($_POST["question_seven_correct"]); $answer_seven_a = mysql_real_escape_string($_POST["answer_seven_a"]); $answer_seven_b = mysql_real_escape_string($_POST["answer_seven_b"]); $answer_seven_c = mysql_real_escape_string($_POST["answer_seven_c"]); $answer_seven_d = mysql_real_escape_string($_POST["answer_seven_d"]); $question_eight = mysql_real_escape_string($_POST["question_eight"]); $question_eight_correct = mysql_real_escape_string($_POST["question_eight_correct"]); $answer_eight_a = mysql_real_escape_string($_POST["answer_eight_a"]); $answer_eight_b = mysql_real_escape_string($_POST["answer_eight_b"]); $answer_eight_c = mysql_real_escape_string($_POST["answer_eight_c"]); $answer_eight_d = mysql_real_escape_string($_POST["answer_eight_d"]); $question_nine = mysql_real_escape_string($_POST["question_nine"]); $question_nine_correct = mysql_real_escape_string($_POST["question_nine_correct"]); $answer_nine_a = mysql_real_escape_string($_POST["answer_nine_a"]); $answer_nine_b = mysql_real_escape_string($_POST["answer_nine_b"]); $answer_nine_c = mysql_real_escape_string($_POST["answer_nine_c"]); $answer_nine_d = mysql_real_escape_string($_POST["answer_nine_d"]); $question_ten = mysql_real_escape_string($_POST["question_ten"]); $question_ten_correct = mysql_real_escape_string($_POST["question_ten_correct"]); $answer_ten_a = mysql_real_escape_string($_POST["answer_ten_a"]); $answer_ten_b = mysql_real_escape_string($_POST["answer_ten_b"]); $answer_ten_c = mysql_real_escape_string($_POST["answer_ten_c"]); $answer_ten_d = mysql_real_escape_string($_POST["answer_ten_d"]); mysql_query("UPDATE reading SET paragraph_one='$paragraph_one', paragraph_two='$paragraph_two', paragraph_three='$paragraph_three', paragraph_four='$paragraph_four', question_one='$question_one', question_one_correct='$question_one_correct', answer_one_a='$answer_one_a', answer_one_b='$answer_one_b', answer_one_c='$answer_one_c', answer_one_d='$answer_one_d', question_two='$question_two', question_two_correct='$question_two_correct', answer_two_a='$answer_two_a', answer_two_b='$answer_two_b', answer_two_c='$answer_two_c', answer_two_d='$answer_two_d', question_three='$question_three', question_three_correct='$question_three_correct', answer_three_a='$answer_three_a', answer_three_b='$answer_three_b', answer_three_c='$answer_three_c', answer_three_d='$answer_three_d', question_four='$question_four', question_four_correct='$question_four_correct', answer_four_a='$answer_four_a', answer_four_b='$answer_four_b', answer_four_c='$answer_four_c', answer_four_d='$answer_four_d', question_five='$question_five', question_five_correct='$question_five_correct', answer_five_a='$answer_five_a', answer_five_b='$answer_five_b', answer_five_c='$answer_five_c', answer_five_d='$answer_five_d', question_six='$question_six', question_six_correct='$question_six_correct', answer_six_a='$answer_six_a', answer_six_b='$answer_six_b', answer_six_c='$answer_six_c', answer_six_d='$answer_six_d', question_seven='$question_seven', question_seven_correct='$question_seven_correct', answer_seven_a='$answer_seven_a', answer_seven_b='$answer_seven_b', answer_seven_c='$answer_seven_c', answer_seven_d='$answer_seven_d', question_eight='$question_eight', question_eight_correct='$question_eight_correct', answer_eight_a='$answer_eight_a', answer_eight_b='$answer_eight_b', answer_eight_c='$answer_eight_c', answer_eight_d='$answer_eight_d', question_nine='$question_nine', question_nine_correct='$question_nine_correct', answer_nine_a='$answer_nine_a', answer_nine_b='$answer_nine_b', answer_nine_c='$answer_nine_c', answer_nine_d='$answer_nine_d', question_ten='$question_ten', question_ten_correct='$question_ten_correct', answer_ten_a='$answer_ten_a', answer_ten_b='$answer_ten_b', answer_ten_c='$answer_ten_c', answer_ten_d='$answer_ten_d', WHERE paragraph_one='$x' ") or die(mysql_error()); $success_message = "Question was edited."; } echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"> <html xmlns=\"http://www.w3.org/1999/xhtml\"> <head> <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" /> <title>Edit Reading Questions & Answers | Online Placement Test | Viva College</title> <link rel=\"stylesheet\" type=\"text/css\" href=\"css.css\" /> </head> <body> <div id=\"timer\"> </div> <div id=\"wrap\"> <div id=\"mainheader\"> </div> <div id=\"editcontent\"> <div id=\"orangeheader\"><br/> Edit Reading Questions & Answers </div> <div id=\"text\"> " . $success_message; if(isset($_POST["edit"])){ $paragraph_one = mysql_real_escape_string($_POST["edit"]); $sql = mysql_query("SELECT * FROM reading WHERE paragraph_one='$paragraph_one'") or die($error_message); while($row = mysql_fetch_array($sql)){ $paragraph_one = $row["paragraph_one"]; $paragraph_two = $row["paragraph_two"]; $paragraph_three = $row["paragraph_three"]; $paragraph_four = $row["paragraph_four"]; $question_one = $row["question_one"]; $question_one_correct = $row["question_one_correct"]; $answer_one_a = $row["answer_one_a"]; $answer_one_b = $row["answer_one_b"]; $answer_one_c = $row["answer_one_c"]; $answer_one_d = $row["answer_one_d"]; $question_two = $row["question_two"]; $question_two_correct = $row["question_two_correct"]; $answer_two_a = $row["answer_two_a"]; $answer_two_b = $row["answer_two_b"]; $answer_two_c = $row["answer_two_c"]; $answer_two_d = $row["answer_two_d"]; $question_three = $row["question_three"]; $question_three_correct = $row["question_three_correct"]; $answer_three_a = $row["answer_three_a"];; $answer_three_b = $row["answer_three_b"]; $answer_three_c = $row["answer_three_c"]; $answer_three_d = $row["answer_three_d"]; $question_four = $row["question_four"]; $question_four_correct = $row["question_four_correct"]; $answer_four_a = $row["answer_four_a"]; $answer_four_b = $row["answer_four_b"]; $answer_four_c = $row["answer_four_c"]; $answer_four_d = $row["answer_four_d"]; $question_five = $row["question_five"]; $question_five_correct = $row["question_five_correct"]; $answer_five_a = $row["answer_five_a"]; $answer_five_b = $row["answer_five_b"]; $answer_five_c = $row["answer_five_c"]; $answer_five_d = $row["answer_five_d"]; $question_six = $row["question_six"]; $question_six_correct = $row["question_six_correct"]; $answer_six_a = $row["answer_six_a"]; $answer_six_b = $row["answer_six_b"]; $answer_six_c = $row["answer_six_c"]; $answer_six_d = $row["answer_six_d"]; $question_seven = $row["question_seven"]; $question_seven_correct = $row["question_seven_correct"]; $answer_seven_a = $row["answer_seven_a"]; $answer_seven_b = $row["answer_seven_b"]; $answer_seven_c = $row["answer_seven_c"]; $answer_seven_d = $row["answer_seven_d"]; $question_eight = $row["question_eight"]; $question_eight_correct = $row["question_eight_correct"]; $answer_eight_a = $row["answer_eight_a"]; $answer_eight_b = $row["answer_eight_b"]; $answer_eight_c = $row["answer_eight_c"]; $answer_eight_d = $row["answer_eight_d"]; $question_nine = $row["question_nine"]; $question_nine_correct = $row["question_nine_correct"]; $answer_nine_a = $row["answer_nine_a"]; $answer_nine_b = $row["answer_nine_b"]; $answer_nine_c = $row["answer_nine_c"]; $answer_nine_d = $row["answer_nine_d"]; $question_ten = $row["question_ten"]; $question_ten_correct = $row["question_ten_correct"]; $answer_ten_a = $row["answer_ten_a"]; $answer_ten_b = $row["answer_ten_b"]; $answer_ten_c = $row["answer_ten_c"]; $answer_ten_d = $row["answer_ten_d"]; } echo "<form action=\"edit_reading.php\" method=\"post\"> <strong>Edit/Update Question</strong><br/> <table> <tr> <td> Paragraph One:<br/> <textarea name=\"paragraph_one\" cols=\"30\" rows=\"5\">" . $paragraph_one . "</textarea> </td> <td> Paragraph Two:<br/> <textarea name=\"paragraph_two\" cols=\"30\" rows=\"5\">" . $paragraph_two . "</textarea> </td> <td> Paragraph Three:<br/> <textarea name=\"paragraph_three\" cols=\"30\" rows=\"5\">" . $paragraph_three . "</textarea> </td> <td> Paragraph Four:<br/> <textarea name=\"paragraph_four\" cols=\"30\" rows=\"5\">" . $paragraph_four . "</textarea> </td> </tr> </table> <table> <tr> <td> Question One:<br/> <textarea name=\"question_one\" cols=\"20\" rows=\"2\">" . $question_one . "</textarea><br/> Option A:<br/> <input type=\"radio\" name=\"question_one_correct\" value=\"a\"> <input type=\"text\" name=\"answer_one_a\" value=\"" . $answer_one_a . "\"/><br/> Option B:<br/> <input type=\"radio\" name=\"question_one_correct\" value=\"b\"> <input type=\"text\" name=\"answer_one_b\" value=\"" . $answer_one_b . "\"/><br/> Option C:<br/> <input type=\"radio\" name=\"question_one_correct\" value=\"c\"> <input type=\"text\" name=\"answer_one_c\" value=\"" . $answer_one_c . "\"/><br/> Option D:<br/> <input type=\"radio\" name=\"question_one_correct\" value=\"d\"> <input type=\"text\" name=\"answer_one_d\" value=\"" . $answer_one_d . "\"/><br/> </td> <td> Question Two:<br/> <textarea name=\"question_two\" cols=\"20\" rows=\"2\">" . $question_two . "</textarea><br/> Option A:<br/> <input type=\"radio\" name=\"question_two_correct\" value=\"a\"> <input type=\"text\" name=\"answer_two_a\" value=\"" . $answer_two_a . "\"/><br/> Option B:<br/> <input type=\"radio\" name=\"question_two_correct\" value=\"b\"> <input type=\"text\" name=\"answer_two_b\" value=\"" . $answer_two_b . "\"/><br/> Option C:<br/> <input type=\"radio\" name=\"question_two_correct\" value=\"c\"> <input type=\"text\" name=\"answer_two_c\" value=\"" . $answer_two_c . "\"/><br/> Option D:<br/> <input type=\"radio\" name=\"question_two_correct\" value=\"d\"> <input type=\"text\" name=\"answer_two_d\" value=\"" . $answer_two_d . "\"/><br/> </td> <td> Question Three:<br/> <textarea name=\"question_three\" cols=\"20\" rows=\"2\">" . $question_three . "</textarea><br/> Option A:<br/> <input type=\"radio\" name=\"question_three_correct\" value=\"a\"> <input type=\"text\" name=\"answer_three_a\" value=\"" . $answer_three_a . "\"/><br/> Option B:<br/> <input type=\"radio\" name=\"question_three_correct\" value=\"b\"> <input type=\"text\" name=\"answer_three_b\" value=\"" . $answer_three_b . "\"/><br/> Option C:<br/> <input type=\"radio\" name=\"question_three_correct\" value=\"c\"> <input type=\"text\" name=\"answer_three_c\" value=\"" . $answer_three_c . "\"/><br/> Option D:<br/> <input type=\"radio\" name=\"question_three_correct\" value=\"d\"> <input type=\"text\" name=\"answer_three_d\" value=\"" . $answer_three_d . "\"/><br/> </td> <td> Question Four:<br/> <textarea name=\"question_four\" cols=\"20\" rows=\"2\">" . $question_four . "</textarea><br/> Option A:<br/> <input type=\"radio\" name=\"question_four_correct\" value=\"a\"> <input type=\"text\" name=\"answer_four_a\" value=\"" . $answer_four_a . "\"/><br/> Option B:<br/> <input type=\"radio\" name=\"question_four_correct\" value=\"b\"> <input type=\"text\" name=\"answer_four_b\" value=\"" . $answer_four_b . "\"/><br/> Option C:<br/> <input type=\"radio\" name=\"question_four_correct\" value=\"c\"> <input type=\"text\" name=\"answer_four_c\" value=\"" . $answer_four_c . "\"/><br/> Option D:<br/> <input type=\"radio\" name=\"question_four_correct\" value=\"d\"> <input type=\"text\" name=\"answer_four_d\" value=\"" . $answer_four_d . "\"/><br/> </td> <td> Question Five:<br/> <textarea name=\"question_five\" cols=\"20\" rows=\"2\">" . $question_five . "</textarea><br/> Option A:<br/> <input type=\"radio\" name=\"question_five_correct\" value=\"a\"> <input type=\"text\" name=\"answer_five_a\" value=\"" . $answer_five_a . "\"/><br/> Option B:<br/> <input type=\"radio\" name=\"question_five_correct\" value=\"b\"> <input type=\"text\" name=\"answer_five_b\" value=\"" . $answer_five_b . "\"/><br/> Option C:<br/> <input type=\"radio\" name=\"question_five_correct\" value=\"c\"> <input type=\"text\" name=\"answer_five_c\" value=\"" . $answer_five_c . "\"/><br/> Option D:<br/> <input type=\"radio\" name=\"question_five_correct\" value=\"d\"> <input type=\"text\" name=\"answer_five_d\" value=\"" . $answer_five_d . "\"/><br/> </td> </tr> <tr> <td> Question Six:<br/> <textarea name=\"question_six\" cols=\"20\" rows=\"2\">" . $question_six . "</textarea><br/> Option A:<br/> <input type=\"radio\" name=\"question_six_correct\" value=\"a\"> <input type=\"text\" name=\"answer_six_a\" value=\"" . $answer_six_a . "\"/><br/> Option B:<br/> <input type=\"radio\" name=\"question_six_correct\" value=\"b\"> <input type=\"text\" name=\"answer_six_b\" value=\"" . $answer_six_b . "\"/><br/> Option C:<br/> <input type=\"radio\" name=\"question_six_correct\" value=\"c\"> <input type=\"text\" name=\"answer_six_c\" value=\"" . $answer_six_c . "\"/><br/> Option D:<br/> <input type=\"radio\" name=\"question_six_correct\" value=\"d\"> <input type=\"text\" name=\"answer_six_d\" value=\"" . $answer_six_d . "\"/><br/> </td> <td> Question Seven:<br/> <textarea name=\"question_seven\" cols=\"20\" rows=\"2\">" . $question_seven . "</textarea><br/> Option A:<br/> <input type=\"radio\" name=\"question_seven_correct\" value=\"a\"> <input type=\"text\" name=\"answer_seven_a\" value=\"" . $answer_seven_a . "\"/><br/> Option B:<br/> <input type=\"radio\" name=\"question_seven_correct\" value=\"b\"> <input type=\"text\" name=\"answer_seven_b\" value=\"" . $answer_seven_b . "\"/><br/> Option C:<br/> <input type=\"radio\" name=\"question_seven_correct\" value=\"c\"> <input type=\"text\" name=\"answer_seven_c\" value=\"" . $answer_seven_c . "\"/><br/> Option D:<br/> <input type=\"radio\" name=\"question_seven_correct\" value=\"d\"> <input type=\"text\" name=\"answer_seven_d\" value=\"" . $answer_seven_d . "\"/><br/> </td> <td> Question Eight:<br/> <textarea name=\"question_eight\" cols=\"20\" rows=\"2\">" . $question_eight . "</textarea><br/> Option A:<br/> <input type=\"radio\" name=\"question_eight_correct\" value=\"a\"> <input type=\"text\" name=\"answer_eight_a\" value=\"" . $answer_eight_a . "\"/><br/> Option B:<br/> <input type=\"radio\" name=\"question_eight_correct\" value=\"b\"> <input type=\"text\" name=\"answer_eight_b\" value=\"" . $answer_eight_b . "\"/><br/> Option C:<br/> <input type=\"radio\" name=\"question_eight_correct\" value=\"c\"> <input type=\"text\" name=\"answer_eight_c\" value=\"" . $answer_eight_c . "\"/><br/> Option D:<br/> <input type=\"radio\" name=\"question_eight_correct\" value=\"d\"> <input type=\"text\" name=\"answer_eight_d\" value=\"" . $answer_eight_d . "\"/><br/> </td> <td> Question Nine:<br/> <textarea name=\"question_nine\" cols=\"20\" rows=\"2\">" . $question_nine . "</textarea><br/> Option A:<br/> <input type=\"radio\" name=\"question_nine_correct\" value=\"a\"> <input type=\"text\" name=\"answer_nine_a\" value=\"" . $answer_nine_a . "\"/><br/> Option B:<br/> <input type=\"radio\" name=\"question_nine_correct\" value=\"b\"> <input type=\"text\" name=\"answer_nine_b\" value=\"" . $answer_nine_b . "\"/><br/> Option C:<br/> <input type=\"radio\" name=\"question_nine_correct\" value=\"c\"> <input type=\"text\" name=\"answer_nine_c\" value=\"" . $answer_nine_c . "\"/><br/> Option D:<br/> <input type=\"radio\" name=\"question_nine_correct\" value=\"d\"> <input type=\"text\" name=\"answer_nine_d\" value=\"" . $answer_nine_d . "\"/><br/> </td> <td> Question Ten:<br/> <textarea name=\"question_ten\" cols=\"20\" rows=\"2\">" . $question_ten . "</textarea><br/> Option A:<br/> <input type=\"radio\" name=\"question_ten_correct\" value=\"a\"> <input type=\"text\" name=\"answer_ten_a\" value=\"" . $answer_ten_a . "\"/><br/> Option B:<br/> <input type=\"radio\" name=\"question_ten_correct\" value=\"b\"> <input type=\"text\" name=\"answer_ten_b\" value=\"" . $answer_ten_b . "\"/><br/> Option C:<br/> <input type=\"radio\" name=\"question_ten_correct\" value=\"c\"> <input type=\"text\" name=\"answer_ten_c\" value=\"" . $answer_ten_c . "\"/><br/> Option D:<br/> <input type=\"radio\" name=\"question_ten_correct\" value=\"d\"> <input type=\"text\" name=\"answer_ten_d\" value=\"" . $answer_ten_d . "\"/> </td> </tr> </table> <br/> <div id=\"center\"><button type=\"submit\" name=\"update\" value=\"" . $paragraph_one . "\">Update</button></div> </form>"; } Link to comment https://forums.phpfreaks.com/topic/203428-keep-getting-mysql-error-message-but-i-have-no-idea-why-or-how-to-fix-it/ Share on other sites More sharing options...
morocco-iceberg Posted May 31, 2010 Author Share Posted May 31, 2010 And I found it just after I posted this... >.<;; extra comma, my bad. Link to comment https://forums.phpfreaks.com/topic/203428-keep-getting-mysql-error-message-but-i-have-no-idea-why-or-how-to-fix-it/#findComment-1065731 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.