MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: Trouble Updating Table with Multiple Rows with Different Values
Posted by: Peter Brawley
Date: October 19, 2015 11:07AM

Read again. I did not suggest putting PHP code in a MySQL Trigger.

The suggestion is that a MySQL Trigger is a much simpler and more efficient solution to the problem of propagating product price changes to orders. Read about Triggers.

You also need to read about the MySQL PHP functions you are using, but unless you can find a strong reason not to use a Trigger to update proces from products to orders, I'll leave that for now.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Trouble Updating Table with Multiple Rows with Different Values
Becca Duran
October 15, 2015 08:41AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
October 15, 2015 12:56PM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
October 19, 2015 09:08AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
October 19, 2015 11:07AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
October 20, 2015 08:59AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
October 20, 2015 01:51PM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
October 21, 2015 07:53AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
October 21, 2015 11:12AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
October 28, 2015 07:18AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
October 29, 2015 11:40AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
November 09, 2015 11:11AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
November 09, 2015 11:26AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
October 21, 2015 09:22AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
October 31, 2015 12:16AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
November 09, 2015 11:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.