SQL syntax error while update sql with php

Question

I have a problem, i try to update a mysql database with my php script but i become the message:

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 'mod = 3, drehtage = 4, schnitttage = 5, dreh = 0, schnitt = 0, off = 0, leiter =' at line 1

i hope you can help me, here is my code to update the database (i just edit the user + pass ;) )

    $con = mysql_connect('localhost', 'user', 'pass');
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }

    mysql_select_db("kup_projekte", $con);

    $aendern = "UPDATE drehs SET name = '".$t1."', drehdatum = '".$t2."', schnittdatum = '".$t3."', kamera = '".$t4."', assi = '".$t5."', mod = '".$t6."', drehtage = '".$t7."', schnitttage = '".$t8."', dreh = '".$t9."', schnitt = '".$t10."', off = '".$t11."', leiter = '".$t12."' Where id = '".$id."'";

    $update=mysql_query($aendern);
    mysql_close($con);

// EDIT //

the variables $t1 - $t12 are filled and comes correctly.

Mark Baker · Accepted Answer · 2012-10-16 11:12:11Z

4

mod is a mysql reserved word. If you want to use it as a column name, you must enclose it in backticks (`) in your SQL queries

answered Oct 16, 2012 at 11:12

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL syntax error while update sql with php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related