Error: You have an error in your SQL syntax; check the manual that corresponds to you

Hi.
I'm getting the following error over and over:
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 ')' at line 5
This is the code:

Expand|Select|Wrap|Line Numbers

 <?

include("begin.php");

SESSION_START ();

?>
 
<html>

<body>

Geef antwoord op de volgende vraag (maar 1 antwoord is goed!):<br />

<b>Is kaas lekker?</b>

<table>

<tr><td><form name="vraag1" action="oefentoets.php" method="post"></td></tr> 

<tr><td><input type="radio" name="vraag1" value="ja" />ja</td></tr>

<tr><td><input type="radio" name="vraag1" value="nee" />nee</td></tr>

<tr><td><input type="submit" value="Volgende" name="knop" /></td></tr>

</form></table>
 
<!-- bovenstaande kan je voor elke vraag aanpassen-->

</body>

</html>
 
<?php

$con = mysql_connect("localhost","XXXXXXXX","XXXXXX");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }
 
 mysql_select_db("zcollege_1342", $con);
 
 $_SESSION['email'] = $_POST['email'];

//$antwoord1 = $_POST['vraag1'];

$vraag1 = $_POST['vraag1'];

echo $_SESSION['email'];
 
if(isset($_POST['knop'])) {

    $sql= "UPDATE oefentoets

    SET vraag1 = '$_POST[vraag1]'

    WHERE id=$id";

if (!mysql_query($sql,$con))

    {

    die('Error: ' . mysql_error());

    }

echo "1 record added";
 
mysql_close($con);

}

?>

Line 5 is empty. There is nothing wrong with the brackets, and even if I remove the last adjustments I made before I started getting this error, it won't go away. So, does anyone have any idea on what's wrong here?
Kind regards,
Ellen

May 23 '12 #1

Subscribe Post Reply

3536

johny10151981

1,059

1GB

Expand|Select|Wrap|Line Numbers

 
$sql= "UPDATE oefentoets

SET vraag1 = '$_POST[vraag1]'

WHERE id=$id";

here in your code you never defined $id. so your actual query is something like below:

Expand|Select|Wrap|Line Numbers

 
UPDATE oefentoets SET vraag1 = 'testvalue'

WHERE id=

you know it must fail :)

May 24 '12 #2

Ellenthe

I defined $id in the included page, begin.php.
The code I used for that:

Expand|Select|Wrap|Line Numbers

 <?php

session_start();

$con = mysql_connect("localhost","XXXXXXX","XXXXX");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }
 
mysql_select_db("zcollege_1342", $con);
 
$sql="INSERT INTO oefentoets (name, email)

VALUES

('$_POST[name]',

'$_POST[email]',

)";

$id = mysql_insert_id(); 
 
if (!mysql_query($sql,$con))

  {

  die('Error: ' . mysql_error());

  }

echo "Gelukt! Je bent nu geregistreerd als: ";

echo $_POST[name];

echo " .";

mysql_close($con)

?>

As you can see, $id does get defined in this section. So, what else could be wrong here?

May 25 '12 #3

johny10151981

1,059

1GB

Well I would suggest you to print the query and see for yourself and then try the query on mysql itself.

May 25 '12 #4

by: entoone | last post by:

I'm getting the following error Parse error: parse error, expecting `','' or `';'' in /home/notarywe/public_html/php/update2.php on line 108 Here is line 108 <input type="text" name="ud_first"...

PHP

Parse error: parse error, unexpected T_ELSE

by: Marten van Urk | last post by:

I got the following error in my page Parse error: parse error, unexpected T_ELSE in line 25 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Club</title>...

PHP

Redirect Error Reported As SQL Syntax Error

by: Steve | last post by:

I just spent waaaaaaaaaaaayy too much time trying to track down an error that was incorrectly reported just now, and I would like to see if someone can explain to me why it was reported that way. ...

PHP

Problems with editing the VBA code - auto syntax check??

by: Krzysztof Bartosiewicz | last post by:

Hi! I have problems with editing my VBA code. It is connected with some kind of automatic-correction mechanism in Access which I cannot find. I turned off Automatic Syntax Check in Options menu...

Microsoft Access / VBA

Error mesage: Error while trying to run project: Unable to start debugging ...

by: Annie | last post by:

Hi guys, I am trying to set the connection string for my database in the web.config file however it raises the funny error message: ""Error while trying to run project: Unable to start...

ASP.NET

Html Unit Error-StrictErrorReporter Error

by: Subanesh | last post by:

Hi All, Am new to using HTMLUnit.I wrote a sample code(to emulate opening of website google.com and enter a value say "html" in the text field and click the Search button) .The code is as follows...

Java

error in mysql query(syntax)

by: ajos | last post by:

hi friends, i have a problem in mysql query..when i click on submit the values get enterred but i get a ever since i did some changes in my code(earlier i was getting a null pointer...

MySQL Database

Error in Update Query Syntax

by: missflorenceokosun | last post by:

hi, am florence. i keep having a runtime error stating error in update query syntax. i have looked through my code over and over gain and seem to find no flaw. i need you guys to help me out! ...

Visual Basic 4 / 5 / 6

SQl Syntax Check

by: FM | last post by:

Hi there: My question is about checking my sql-syntax against DB2UDB V9 throug JDBC 2.0 Is there a way to check my syntax,for example "select * from T1"? Thank you for your help. Regards,

DB2 Database

You have an error in your SQL syntax; check the manual that corresponds to your MySQL

by: sathishauit | last post by:

<?php require_once ("inc/dbconnection.php"); class provider_function { public $select_query; public $select_result; public $insert_query; public $insert_result; public $update_query;

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Error: You have an error in your SQL syntax; check the manual that corresponds to you

Similar topics