Sale!

(Solved) : Trying Update Database Php Script Following Sql Insertsql Alter Table Nmcrecords Recordid Q34184958

$ 16.00

Answer to I am trying to update a database through a PHP script with the following SQL: $insertSQL = “ALTER TABLE `nmc_records` (‘…

SKU: e012eea6a493 Category:

Description

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 ... View full description