[RESOLVED] How is this possible???

stebut05

Hi all,

I hope someone can help me with this problem. I have a query that selects shipping details from a customer account. The i have a second query to count the weight of all the products in the shipping query. How do i count all the weights of products and display the result??

Shipping query:

$query = "SELECT * FROM Shipping, Customers, Orders, Delivery_Zones  
		  WHERE Delivery_Zones.zone_id = Orders.delivery_zone AND Shipping.order_id = Orders.order_id AND Customers.customer_id = Orders.customer_id AND dispatch_date = '$dispatchdate'";

As you can see there can be more than one set of results for this query

Product weight query:
$order_id = $rows['order_id'];

$query2 = "SELECT * FROM Product_Description, Order_Details 
		  WHERE Product_Description.product_id = Order_Details.product_id AND Order_Details.order_id = '$order_id'";

The finally my script to count the weight of products

		  $weight = $rows2['product_weight'];
		  $totalweight =+ $weight;	
		  echo $totalweight;

I really appreciate any help, advice given in advance.

Regards,

Steven

coreyp_1

I assume you are using MySQL? You can have MySQL do the math for you using something like this:

$query = "SELECT od.order_id, SUM(product_weight) AS weight
  FROM Order_details od
  LEFT JOIN Product_Description pd
  USING product_id
  GROUP BY pd.order_id";

Now, can also combine the two queries into one larger query, if you are needing the weight for each order at the same time as the other information about that order (such as to display the information in a list). Let me know if you are interested in that.

stebut05

thanks for your help, now resolved

Regards,

Steven

subwayman

Quick tutorial:

$handle = fopen("/home/rasmus/file.txt", "r"); will oen a file for read only

$line = fgets($handle); will read a line from the file into $line (or up to 1024 bytes if no new line character or end of file is hit)

while (!feof($handle)) {

...

}

Will allow you to run through a file until the end