Problem in MySQLi query

Question

This query produces 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 1

Maybe becuase I'm tired, I am not findhing the problem here...

mysqli_query($db, "INSERT INTO `tbl_bugresponse` (`id`, `bugid`, `by`, `content`, `time`) VALUES ('NULL', '$id', '$name', '$content', '$dt'") or die(mysqli_error($db));

thanks:)

Answer 1

closing bracket on sql is missing, you only have closing bracket for mysqli_query function

Answer 2

You probably want this:

mysqli_query($db, "INSERT INTO `tbl_bugresponse` (`id`, `bugid`, `by`, `content`, `time`) VALUES (NULL, '$id', '$name', '$content', '$dt')") or die(mysqli_error($db));

Also, the query you've provided is open to SQL injection attacks. I'd suggest looking up parameterised queries.