I am trying to update multiple rows in my database using php and mysql.
Here is my php mysql statment:
$sql = "UPDATE book_store SET". "title = '$_POST[title]', isbn = '$_POST[isbn]', price = '$_POST[price]', quantity = '$_POST[quantity]' ". "WHERE ID = '$_POST[id]' ";
Here is my Error:
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 '= 'PHP and MySQL Web Development', isbn = '0672329166', price = '34.43', quantit' at line 1
What am I doing wrong?