sql syntax error check manual

Question

i am new to php programming. I always get this error when i run my code

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 service_name = ''' at line 7

this is my code

<?php
session_start();
include('../conn/openconn.php');
if(isset($_POST['butsend'])) {

$servicename = strtoupper($_POST['txtservicename']);
$serviceurl = $_POST['txtserviceurl'];
$id_div = $_POST['select_div'];
$id_unit = $_POST['select_unit'];
$servicedesc = $_POST['txtservicedesc'];
$id = $_SESSION['service_name'];

$updateuser = "UPDATE service SET 
               service_name = '$servicename',
               service_url = '$serviceurl',              
               id_div = '$id_div',
               id_unit = '$id_unit',
               service_desc = '$servicedesc',
               WHERE service_name = '$id'";
    mysql_query($updateuser) or die (mysql_error());

}

?>

i have already search all the previous question but due to my limited knowledge in the programming i cannot find the solution. sorry for my bad english..

John Conde · Accepted Answer · 2014-11-19 01:42:27Z

2

You have an extra comma. Remove it.

$updateuser = "UPDATE service SET 
           service_name = '$servicename',
           service_url = '$serviceurl',              
           id_div = '$id_div',
           id_unit = '$id_unit',
           service_desc = '$servicedesc', <-- HERE
           WHERE service_name = '$id'";

answered Nov 19, 2014 at 1:42

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

Collectives™ on Stack Overflow

sql syntax error check manual

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