Update.php

check this page i need this

UPDATE summary_data
SET current_category = (SELECT category_id
   FROM products
   WHERE products.product_id = summary_data.product_id)
WHERE EXISTS (SELECT category_id
   FROM products
   WHERE products.product_id = summary_data.product_id);

but i need update email and password from customer tabela to user1

As before, you haven’t provided enough information about what it is you want to do. If you’re asking these kinds of questions it implies you don’t understand the basics, I would strongly recommend working through some tutorials aimed at beginners so you can get a good grasp of the basics. As it stands, you’ll keep doing as you are and coming here every time you get stuck.

Otherwise, what have you tried so far? Rather than copying/pasting code from elsewhere, what have you tried and where did you get stuck?

3 Likes

I solved the problem

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.