Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Oct 2012
    Posts
    44
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Add Columns SQL AND PHP

    Code:
    <?php
    	require('includes/header.php');
    	
    ?>
    
    <h4> <ul id="menu">
    <li><p><a href="customer_details.php">Customer Details</a></p></li>
    <li><p><a href="order_customer_details.php">Details by order</a></p></li>
    <li><p><a href="country_list.php">Customers by Country</a></p></li>
    <li><p><a href="categories.php">Products by category</a></p></li>
    <li><p><a href="low_stock.php">Low Stock Items</a></p></li>
    <li><p><a href="index.php">Home</a></p></li>
    </ul></h4>
    
    
    <?php
    	$sql = "SELECT customers.CompanyName, orders.CustomerID, orders.OrderID, order_details.OrderID, order_details.ProductID, products.ProductID, products.ProductName, order_details.UnitPrice, order_details.Quantity, orders.shipVia, shippers.shipperId, shippers.CompanyName, orders.Freight
    	FROM customers, orders, order_details, products, shippers
    	WHERE customers.CustomerID = orders.CustomerID
    	AND orders.OrderID = '" . $_GET['order'] . "%'
    	AND orders.OrderID = order_details.OrderID
    	AND order_details.ProductID = products.productID
    	AND orders.ShipVia = shippers.ShipperID
    	ORDER BY products.productName, products.UnitsInStock, products.UnitPrice, shippers.CompanyName, orders.Freight";
    	
    	$result = mysql_query($sql) or die(mysql_error());
    
    	
    echo "<table border='1'>
    <tr>
    <th>Product Name</th>
    <th>Quantity</th>
    <th>Unit Price</th>
    <th>Shipper</th>
    <th>Shipping Cost</th>
    <th>Total Cost</th>
    </tr>";
    while($row = mysql_fetch_array($result))
      {
      echo "<tr>";
      echo "<td>" . $row['ProductName'] . "</td>";
      echo "<td>" . $row['Quantity'] . "</td>";
      echo "<td>" . $row['UnitPrice'] . "</td>";
      echo "<td>" . $row['CompanyName'] . "</td>";
      echo "<td>" . $row['Freight'] . "</td>";
      //echo "<td>""</td>";
      }
    echo "</table>";
    		
    ?>
    
    
    
    <?php
    require('includes/footer.php'); 
    
    ?>
    I want to add the number from the Total Cost column into something below that says: The total cost for this order is: and echo that amount.

  • #2
    Regular Coder Redcoder's Avatar
    Join Date
    May 2012
    Location
    /dev/null
    Posts
    333
    Thanks
    2
    Thanked 47 Times in 46 Posts
    The SUM of the column should do it. Notice it is the first thing in the query -not because it has to be done like that but because I didn't want it to get lost in the sea of columns and tables in the query.

    PHP Code:
    $sql "SELECT SUM(order_details.UnitPrice) as TotalPrice, customers.CompanyName, orders.CustomerID, orders.OrderID, order_details.OrderID, order_details.ProductID, products.ProductID, products.ProductName, order_details.UnitPrice, order_details.Quantity, orders.shipVia, shippers.shipperId, shippers.CompanyName, orders.Freight
        FROM customers, orders, order_details, products, shippers
        WHERE customers.CustomerID = orders.CustomerID
        AND orders.OrderID = '" 
    $_GET['order'] . "%'
        AND orders.OrderID = order_details.OrderID
        AND order_details.ProductID = products.productID
        AND orders.ShipVia = shippers.ShipperID
        ORDER BY products.productName, products.UnitsInStock, products.UnitPrice, shippers.CompanyName, orders.Freight"



  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •