Member Avatar for kira_

I always get this error:
"Error updating joke: 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 '1' at line 1"

There's something about this part of my code that causes that error and I just can't figure out what that is. help please :(

$id = mysql_real_escape_string($_POST['id']);
	$text = mysql_real_escape_string($_POST['text']);
	$sql = mysql_query("UPDATE joke SET joketext='$text' WHERE id=$id");
  • 5 Contributors
  • 4 Replies
  • 193 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by faroukmuhammad
Member Avatar for ko ko

Make sure that the field names are correct. Anyway, post the codes above of these three lines. It may easy to find the problem quickly.

Member Avatar for hielo

try:

$sql = mysql_query("UPDATE joke SET joketext='$text' WHERE id='$id'") or die( mysql_error() );

notice the apostrophes around the value of $id

Member Avatar for Stefano Mtangoo

I always get this error:
"Error updating joke: 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 '1' at line 1"

There's something about this part of my code that causes that error and I just can't figure out what that is. help please :(

$id = mysql_real_escape_string($_POST['id']);
	$text = mysql_real_escape_string($_POST['text']);
	$sql = mysql_query("UPDATE joke SET joketext='$text' WHERE id=$id");

comment the above codes and replace with this and post its output

$id = mysql_real_escape_string($_POST['id']);
$text = mysql_real_escape_string($_POST['text']);
$sql = mysql_query("UPDATE joke SET joketext='$text' WHERE id=$id");
print_r($_POST);
echo "<br />";
echo $sql;
die();
Edited by Stefano Mtangoo because: n/a
Member Avatar for faroukmuhammad

I tre your code the only problem is the connection identifier that you didn't add in mysql_query. this is my code;

<?php
$con = mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("joking", $con);


$id = mysql_real_escape_string($_POST['id']);	
$text = mysql_real_escape_string($_POST['text']);	

$pre_sql = "UPDATE joke SET joketext='$text' WHERE id=$id";
$sql = mysql_query($pre_sql, $con);	

?>

i called the database joking ;)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.