Mysql syntax error on update

Question

I have been staring at this query for ages trying to figure out why I am getting the error as stated in the title and for the life of me cannot see hot to correct it. All fields are correct and all POST values are being posted correctly. I would be grateful if someone with fresh eyes could point out the error. Many thanks.

$id = $_POST['id'];
$rack = strtoupper($_POST['slot']);
$column = $_POST['column']; <---INT
$row = $_POST['row']; <---INT
$bay = $_POST['bay']; <---INT
$size = $_POST['size'];
$service = ucfirst($_POST['service']);
$activity = ucwords($_POST['activity']);
$dept = $_POST['dept'];
$company = $_POST['company'];
$address = ucwords($_POST['address']);
$user = ucwords($_POST['user']);
$box = $_POST['item

'];

$query = "UPDATE `boxes` SET `rack` = '".$rack."',`column` = $column,`row` = $row,`bay` = $bay,`status` = '1',`customer` = '".$company."', `department` = '".$dept."',`request` = 0,`custref` = '".$box."',`size` = '".$size."',`authorisation` = '".$user."' WHERE `department` = '".$dept."',`customer` = '".$company."',`custref` = '".$box."'";
      mysqli_query($conn, $query) or die('Error, box action failed'. mysqli_error($conn));

check the where clause, you have error in your where clause. — Sugumar Venkatesan
– Sugumar Venkatesan, Commented Jun 15, 2018 at 9:48
@kerbholz I'm staring but still cannot see it? could you point it out. thanks — user1532468
– user1532468, Commented Jun 15, 2018 at 9:51

flyingfox · Accepted Answer · 2018-06-15 09:52:51Z

2

You should use AND instead of , in WHERE

Change

WHERE `department` = '".$dept."',`customer` = '".$company."',`custref` = '".$box."'";

to

WHERE `department` = '".$dept."' AND `customer` = '".$company."' AND `custref` = '".$box."'";

answered Jun 15, 2018 at 9:52

flyingfox

13.5k4 gold badges30 silver badges43 bronze badges

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

Comments

A. Colonna · Accepted Answer · 2018-06-15 11:26:18Z

0

In your where it's not , it's and between the clauses:

$query = "UPDATE `boxes` SET `rack` = '".$rack."',`column` = $column,`row` = $row,`bay` = $bay,`status` = '1',`customer` = '".$company."', `department` = '".$dept."',`request` = 0,`custref` = '".$box."',`size` = '".$size."',`authorisation` = '".$user."' WHERE `department` = '".$dept."' AND `customer` = '".$company."' AND `custref` = '".$box."'";
  mysqli_query($conn, $query) or die('Error, box action failed'. mysqli_error($conn));

edited Jun 15, 2018 at 11:26

answered Jun 15, 2018 at 9:53

A. Colonna

8827 silver badges10 bronze badges

Collectives™ on Stack Overflow

Mysql syntax error on update

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related