I'm trying to update multiple columns at once in my database. The updated information is coming from another form page. This is my code and below it is the error. I have also tried this with single quotes and no brackets and I receive the same error message without the brackets with quotes.line 21> $query = "UPDATE inventory SET type = $type [, order = $order] [WHERE id = $id] LIMIT 1";could not execute query.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 '[, order = 02] [WHERE id = 2] LIMIT 1' at line 21Below works fine for a single column, so the connection gets made.line 21> $query = "UPDATE vehicles SET type='$type' WHERE id='$id' LIMIT 1";Thank you in advance for any help offered.