ARRAY Question ...

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
nwoutback
Forum Newbie
Posts: 17
Joined: Mon Nov 24, 2003 1:50 pm

ARRAY Question ...

Post by nwoutback »

I'm using this to pull all columns from a table and list column names and SUMS ... I've got 8 distributors 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();
}

?>
User avatar
Lord Sauron
Forum Commoner
Posts: 85
Joined: Tue Apr 20, 2004 5:53 am
Location: Tilburg, NL

Post by Lord Sauron »

First of all you should request the distributor name in the query if you want this to work. Secondly, your trying to 'sum' $columns? Isn't the result always 1?

Secondly, I would be able to help you, of you would tell me, what your db table structure looks like.
Post Reply