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>"; } Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.