SQL Update Column on new Datarow

Question

I've a MySQL server and I'm running a WebShop on it. Is it possible to calculate the sum of all articles on an order. Now when I add a new row I have to call a method in my PHP Script to calculate the sum. Is this possible to automate in MySQL (ex. Procedures)?

With Best Regards Kevin Horvat

My SQL Query looks like: SELECT SUM(tbl_articles.price) FROM ztbl_articles_orders INNER JOIN tbl_articles ON ztbl_articles_orders.articleID = tbl_articles.articleID INNER JOIN tbl_orders ON ztbl_articles_orders.orderID = tbl_orders.orderID WHERE tbl_orders.userID = 3; — Kevin Horvat, Jan 28 '15 at 10:21
Now i want to save the result of the query and update another row in an other table with this result :) Is this possible? — Kevin Horvat, Jan 28 '15 at 10:23

score 0 · Accepted Answer · answered Jan 29 '15 at 09:03

$query="SELECT SUM(tbl_articles.price) as sum FROM ztbl_articles_orders INNER JOIN tbl_articles ON ztbl_articles_orders.articleID = tbl_articles.articleID INNER JOIN tbl_orders ON ztbl_articles_orders.orderID = tbl_orders.orderID WHERE tbl_orders.userID = 3;";
$result= mysqli_query($connection,$query);
$row=mysqli_fetch_array($result,MYSQLI_BOTH);
$sum=$row['sum'];

"$sum" gets the value you want, now you can insert or update with this value.

Yes that Worked very well. Thanks very much :) – Kevin Horvat Feb 06 '15 at 08:01 — Kevin Horvat, Feb 06 '15 at 08:01

SQL Update Column on new Datarow

1 Answers1