Unsupported Screen Size: The viewport size is too small for the theme to render properly.

update query

forums › forums › update query

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • March 5, 2003 at 3:07 pm #7737
      USER562
      Member

      I keep getting an error message “You have an error in your SQL syntax near SET” when using the mysql statement to update a field in one table based in info in another table.

      I have a category field in one table which is emptied an re-populated on user request.

      I want to update the category field in this table with the category from a products listing table.

      The select version of the update query is as follows……..

      “SELECT Backorders.Style, Backorders.Colour, Backorders.Catlg, product_details.Cat FROM Backorders INNER JOIN product_details ON (Backorders.Style = product_details.Style) AND (Backorders.Colour = product_details.Colour);”

      This code works fine, but when I amend the code to update the table it causes an error.

      Any ideas ?

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.