I am trying to update a database through a PHP script with thefollowing SQL: $insertSQL = “ALTER TAB

I am trying to update a database through a PHP script with thefollowing SQL: $insertSQL = “ALTER TABLE `nmc_records` (‘recordID’, ‘recordTitle’, ‘recordYear’, ‘pubID’, ‘catID’, ‘recordPrice’) VALUES (‘$recordID’, ‘$recordTitle’, ‘$recordYear’, ‘$recordPublisher’, ‘$recordCategory’,’$recordPrice’)”; However I keep getting an error saying: “Error: ALTER TABLE `nmc_records` (‘recordID’, ‘recordTitle’,’recordYear’, ‘pubID’, ‘catID’, ‘recordPrice’) VALUES (”, ”, ”,”, ”,”)

You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax touse near ‘(‘recordID’, ‘recordTitle’, ‘recordYear’, ‘pubID’,’catID’, ‘recordPrice’) ‘ at line 1″ What is the problem with my code and how can it be fixed tofunction correctly and update the database? Attached

Looking for a similar assignment? Get help from our qualified experts!

"Our Prices Start at $9.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!":

Order a Similar Paper Order a Different Paper