I have a script, where there is an error with the SQL string. It uses a simple Mysqli query to run it. Here is the 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 ‘WHERE product_id = ‘65’’ at line 1
and the relevant code:
$sql=“SELECT model, sku, location, quantity, stock_status_id, image, manufacturer_id, shipping, price, points, tax_class_id, date_available, weight, weight_class_id, length, width, height, length_class_id, subtract, minimum, sort_order, status, date_added, date_modified, viewed WHERE product_id = ‘65’”;
$res = mysqli_query($conn,$sql) or die("Error: ".mysqli_error($conn));
Help as to why I am getting the error is appreciated.