adding different variables

jsantama

I have a very large database (658,000+ Records) and I have
to be able to search by zip code or state, and the results from
some of those variables need to be added and displayed.

The searching part I've got it done, but the adding, this is where I'm stuck.

Here is the code, hopefully somebody
could tell me what I'm doing wrong.

$Query = "SELECT zipcode, carrierrouteid, arescentral, 
arescurb, aresndcbu, aresother, 
aresfacility, arescontract, aresdetached, 
aresnpu, prescentral, prescurb, presndcbu,
presother, presfacility, prescontract, 
presdetached, presnpu

	FROM $Table 

	WHERE stateabbrev='$stateabbrev'";

$Result = mysql_db_query ($DB, $Query, $Link);

//table

print ("<table border=1 cellspacing=2 cellpadding=2 align=center>\n");

print ("<tr align=center valign=top>\n");

print ("<td align=center valign=top>ZIP CODE</td>\n");

print ("<td align=center valign=top>Carrier Route</td>\n");

print ("<td align=center valign=top>Active</td>\n");

print ("<td align=center valign=top>Possible</td>\n");

print ("</tr>\n");

//fetch results

while ($Row = mysql_fetch_array
	($Result)) {

print ("<tr align=center valign=top>\n");

print ("<td align=center valign=top>$Row[zipcode]</td>\n");

print ("<td align=center valign=top>$Row[carrierrouteid]</td>\n");

print ("<td align=center valign=top>sum($Row[arescentral], $Row[arescurb], $Row[aresndcbu], 
		$Row[aresother], $Row[aresfacility], $Row[arescontract], $Row[aresdetached], 
		$Row[aresnpu]</td>\n");

print ("<td align=center valign=top>sum($Row[prescentral], $Row[prescurb], $Row[presndcbu], 
		$Row[presother], $Row[presfacility], $Row[prescontract], $Row[presdetached], 
		$Row[presnpu]</td>\n");

print ("</tr>\n");
}

Here is the output that I get:

sum(0, 0, 0, 0, 0, 0, 0, 0 instead of 0

Thank you in advance

nnichols

There is no php function "sum()". Try -

print ("<td align=center valign=top>" . ($Row[arescentral] + $Row[arescurb] + $Row[aresndcbu] + 
$Row[aresother] + $Row[aresfacility] + $Row[arescontract] + $Row[aresdetached] + 
$Row[aresnpu]) . "</td>\n");

Hope this helps 😉

jsantama

Thanks nnichols. It seems to work, although now I'm getting the following errors:

Notice: Use of undefined constant arescentral - 
assumed 'arescentral' in c:\inetpub\wwwroot\usps\sum.php 
on line 63

and so on for all my lines. These lines,
ie 63 are part of the expressions

print ("<td align=center valign=top>" . ($Row[arescentral] + 
$Row[arescurb] + 
$Row[aresndcbu] + 
$Row[aresother] + 
$Row[aresfacility] + 
$Row[arescontract] + 
$Row[aresdetached] + 
$Row[aresnpu]) . "</td>\n");

so now, I'm confused. It did give me the
results by adding them, though.😕

Thanks.

nnichols

print ("<td align=center valign=top>" . ($Row['arescentral'] + $Row['arescurb'] + $Row['aresndcbu'] + 
$Row['aresother'] + $Row['aresfacility'] + $Row['arescontract'] + $Row['aresdetached'] + 
$Row['aresnpu']) . "</td>\n");

jsantama

nnichols,

Thanks a lot for your help. I will try that solution on Monday, and will let you know if that did it. Once again thanks.

jsantama

My page is working!!!! Thanks a lot. Now, I have another question:

Right now, the results are like these:

66002 25 31
66002 15 48
66002 9 58
66006 88 36
66006 8 10
66018 97 505
and so on

I want to group them by zipcode as 66002 and the sum of all 66002s and so on.
If I put in my query GROUP BY zipcode, it only takes one of the cells,
not all of them, so I guess the question is,
how do I do it. My query is as follows:

$Query = "SELECT zipcode, carrierrouteid, arescentral, 
arescurb, aresndcbu, aresother, 
aresfacility, arescontract, aresdetached, 
aresnpu, prescentral, prescurb, 
presndcbu, presother, presfacility, 
prescontract, presdetached, presnpu

	FROM $Table 

	WHERE stateabbrev='$stateabbrev'";

Thanks