MYSQL query doesn't work as it should

Question

$sql = "UPDATE `shows` SET `title` = '$title', `tagline` = '$tagline', `desc` = '$desc' , `img_src = '$imgsrc' WHERE id = $showid";

The above query doesn't want to work, I just get mysql_error with the message "'on line 1;

Any idea where I am going wrong?

+3

nmyster 11 Feb 13 at 18:04

1 answer

John conde · Accepted Answer · 2013-02-11T18:06:11+0000

You are missing a check mark:

   `img_src = '$imgsrc' WHERE id = $showid";

it should be:

   `img_src` = '$imgsrc' WHERE id = $showid";