Jump to content

Keep getting mySQL error message but I have no idea why or how to fix it...


Recommended Posts

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>";
}

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.