Page 1 of 1

ARRAY QUESTION ...

Posted: Wed Nov 26, 2003 5:13 am
by nwoutback
I'm using the below code to pull all columns from a table and list the column names and SUM totals of their content ... I've got 8 distributor records in this table, and I'd like to pull columns and SUMS of, per distributor ... How?

<?php

$connection=mysql_connect("localhost","user","pw") or die('Could not connect to the database server');
$db = mysql_select_db("tanaka-ism_com", $connection) or die ("Unable to select database.");

$columns = array("AST210","AST210Sales","TBC2251","TBC2251Sales");

foreach($columns as $columns)
{
$query = "SELECT SUM($columns) FROM distreport03 WHERE RptDist = 'Gardner'";
$mysqlresult = mysql_query($query);
$result = mysql_fetch_array($mysqlresult);
echo "{$columns} : {$result[0]}<br />";
mysql_free_result();
}

?>

Posted: Wed Nov 26, 2003 12:19 pm
by infolock