Urgent help please
Posted: Sun Oct 16, 2005 2:58 pm
feyd | Please use
That is my query, i need to be able to calculate the total weight of products ordered, but it seems to be just counting all the weights for all the orders
Here is my html
Really appreciate any help, advice given thanks
Regards,
Steven
feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
Hi all,
I have a problem counting or looping through a variable and i am hoping you can help. Really appreciate any help with this problem as i need it resolved for tomorrow morning.
I need to produce a report that lists shipping details and counts the total product weight of each order on the report.Code: Select all
$query = "SELECT Orders.order_id, Orders.dispatch_date, Customers.customer_title, Customers.customer_firstname, Customers.customer_lastname, Product_Description.product_weight,
Shipping.s_company, Shipping.s_building, Shipping.s_address_line_one, Shipping.s_address_line_two, Shipping.s_city, Shipping.s_county,
Shipping.s_country, Shipping.s_post_code, Shipping.s_telephone, Shipping.s_comments
FROM Shipping, Customers, Orders, Product_Description, Order_Details
WHERE Product_Description.product_id = Order_Details.product_id AND Order_Details.order_id = Orders.order_id AND Shipping.order_id = Orders.order_id AND Customers.customer_id = Orders.customer_id AND dispatch_date = '$dispatchdate'";
$results = mysql_query($query) or die(mysql_error());
$rows = mysql_fetch_assoc($results);That is my query, i need to be able to calculate the total weight of products ordered, but it seems to be just counting all the weights for all the orders
Here is my html
Code: Select all
<?php
if ($rows > 0) { // Show if recordset not empty ?>
<table width="574">
<?php do { ?>
<tr>
<td width="104" height="20" class="headingbackgroundtwo">Order Number </td>
<td width="120" class="headingbackground"><?php echo $rows['order_id']; ?></td>
<td width="106"> </td>
<td colspan="2" class="headingbackgroundtwo">Shipping Details </td>
</tr>
<tr>
<td height="22" class="headingbackgroundtwo">Customer</td>
<td class="headingbackground"><?php echo $rows['customer_title']; ?> <?php echo $rows['customer_firstname']; ?> <?php echo $rows['customer_lastname']; ?></td>
<td> </td>
<td width="108" class="headingbackgroundtwo">Company</td>
<td width="112" class="headingbackground"><?php echo $rows['s_company']; ?></td>
</tr>
<tr>
<td height="22" class="headingbackgroundtwo">Product Weight </td>
<td class="headingbackground">
<?php
$weight = $rows['product_weight'];
$totalweight += $weight;
echo $totalweight;
?>
</td>
<td> </td>
<td class="headingbackgroundtwo">Building</td>
<td class="headingbackground"><?php echo $rows['s_building']; ?></td>
</tr>
<tr>
<td height="22"> </td>
<td> </td>
<td> </td>
<td class="headingbackgroundtwo">Address One </td>
<td class="headingbackground"><?php echo $rows['s_address_line_one']; ?></td>
</tr>
<tr>
<td height="22" colspan="2" class="headingbackgroundtwo">Shipping Comments</td>
<td> </td>
<td class="headingbackgroundtwo">Address Two </td>
<td class="headingbackground"><?php echo $rows['s_address_line_two']; ?></td>
</tr>
<tr>
<td colspan="2" rowspan="4" class="headingbackground"><?php echo $rows['s_comments']; ?></td>
<td height="22"> </td>
<td class="headingbackgroundtwo">City</td>
<td class="headingbackground"><?php echo $rows['s_city']; ?></td>
</tr>
<tr>
<td height="22"> </td>
<td class="headingbackgroundtwo">County</td>
<td class="headingbackground"><?php echo $rows['s_county']; ?></td>
</tr>
<tr>
<td height="22"> </td>
<td class="headingbackgroundtwo">Post Code </td>
<td class="headingbackground"><?php echo $rows['s_post_code']; ?></td>
</tr>
<tr>
<td height="22"> </td>
<td class="headingbackgroundtwo">Telephone</td>
<td class="headingbackground"><?php echo $rows['s_telephone']; ?></td>
</tr>
<tr>
<td height="22" colspan="5">---------------------------------------------------------------------------------------------------------------------------------------------</td>
</tr>
<?php } while ($rows = mysql_fetch_assoc($results)); ?>Really appreciate any help, advice given thanks
Regards,
Steven
feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]