$query = "SELECT e.component_1, o.component_2, SUM(e.quantity_1), SUM(o.quantity) FROM equip_ments e LEFT JOIN outbound o ON e.serial_num=o.serial_num GROUP BY component_1";
    $result = mysql_query($query) or die(mysql_error());
   
	
while($row = mysql_fetch_array($result)){

$y = $row['SUM(e.quantity_1)'];
$x = $row['SUM(o.quantity)'];

$query = "SELECT e.component_1, o.component_2, SUM(e.quantity_1), SUM(o.quantity) FROM equip_ments e LEFT JOIN outbound o ON e.serial_num=o.serial_num GROUP BY component_1";

$y = $row['SUM(e.quantity_1)'];

<?php
/*
 * PHP code to export MySQL data to CSV
 * http://911-need-code-help.blogspot.com/2009/07/export-mysql-data-to-csv-using-php.html
 *
 * Sends the result of a MySQL query as a CSV file for download
 */

/*
 * establish database connection
 */

$conn = mysql_connect('localhost',

<?php
mysql_connect ("localhost",

<?php
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "trial";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) 
or die("Opps some thing went wrong");
mysql_select_db($mysql_database,

<?php
include("config.php");
session_start();